Transfer data from one Access database to another

[Luvin lunch]

Hi,

I've developed a worklist system in Access and I plan to deploy four
copies of it to the four users that need it. I said I'll be deploying
copies because there is no shared network in the cave I'm working in.
Each of the users will have their own copy and work on it on their own
machines. It's so 1989 I dunno what to do with myself.

Anyway, the manager wants to get a copy of each user's data once a
month. So to my problem. I need to develop functionality that will
export each of the user's data in a format that can be emailed once a
month. The manager wants then to be able to upload the information
from the email into a master copy of the database. The unique IDs
won't be a problem but the reason I'm posting is that I'm wondering
could anyone suggest the best means of exporting the data so it can be
emailed and then uploaded to a master database with the exact same data
structure.

Any advice would be greatly appreciated

Luvin Lunch

[John Thomas Smith]

On 23 Jan 2007, "Luvin lunch" <ma************@o2.iewrote:

>Anyway, the manager wants to get a copy of each user's data once a
month. So to my problem. I need to develop functionality that will
export each of the user's data in a format that can be emailed once a
month. The manager wants then to be able to upload the information
from the email into a master copy of the database. The unique IDs
won't be a problem but the reason I'm posting is that I'm wondering
could anyone suggest the best means of exporting the data so it can be
emailed and then uploaded to a master database with the exact same data
structure.

While not EXACTLY what you want, I do something similar

I have a handheld barcode reader, which I use to log incoming
items at a mailroom receiving dock... ups or fedex tracking
number, and some other info I either type in manaully (the
scanner I bought has a full keypad) or from a list of codes
I made and printed and pin to a corkboard for standard stuff

Anyway, the scanner then has a function to export the data in
a comma delimited text file, which I transfer to my computer
using a scanner/vendor supplied serial port and software

Once on my computer, I wrote a macro to go to my specified
hard drive location and import the data

Since I specified the data structure on the scanner, I just
made it the same as the Access structure... so the import
works to bring the records into the database every day

Here is the macro
Action is TransferText

Then down in the Action Arguments
Transfer Type Import Delimited
Specification Name Receive Import Specification
Table Name Receive
File Name C:\Scanner\receive.txt
Has Field Names No
HTML Table Name (left blank)

Hopefully, enough to get you going in the right direction

[Lyle Fairfield]

Luvin lunch wrote:

Hi,

I've developed a worklist system in Access and I plan to deploy four
copies of it to the four users that need it. I said I'll be deploying
copies because there is no shared network in the cave I'm working in.
Each of the users will have their own copy and work on it on their own
machines. It's so 1989 I dunno what to do with myself.

Anyway, the manager wants to get a copy of each user's data once a
month. So to my problem. I need to develop functionality that will
export each of the user's data in a format that can be emailed once a
month. The manager wants then to be able to upload the information
from the email into a master copy of the database. The unique IDs
won't be a problem but the reason I'm posting is that I'm wondering
could anyone suggest the best means of exporting the data so it can be
emailed and then uploaded to a master database with the exact same data
structure.

Any advice would be greatly appreciated

Luvin Lunch

The code

SaveAText 6, "", FilePathandName

should make the smallest possible file (FilePathandName) copy of the
data in each of your user's databases. This could be zipped and
appended to an e-mail. At the receving end it should be quite easy to
unzip the file and append it to the master db. A few lines of code
including some SQL should suffice.

[Luvin lunch]

Hi,

Thanks for the responses. John Thomas Smith, I had been considering
using macros so it's good to know that works well for you. Lyle
Fairfield, is there some reference I need to add to my project to
obtain access to the function SaveAText or am I missing your meaning?

Thanks

LL

[Lyle Fairfield]

"Luvin lunch" <ma************@o2.iewrote in news:1169640040.441858.152450
@l53g2000cwa.googlegroups.com:

Lyle
Fairfield, is there some reference I need to add to my project to
obtain access to the function SaveAText or am I missing your meaning?

We both need to spell it correctly:

SaveAsText