By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Transfer data from one Access database to another

P: n/a
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

Jan 23 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jan 23 '07 #2

P: n/a
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.

Jan 23 '07 #3

P: n/a
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

Jan 24 '07 #4

P: n/a
"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
Jan 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.