export a table to another database

[Shannon]

What I'm going to have are many tables from databases going into one big table in another database. So what I invision is a command button (excuting a macro) to export that database into a file (?). Then the person maintain the big database downloading it into the database. Any ideas? I have never dealt with exporting tables to another database. Thank for any input.

 

[Ken Grubb]

Sounds like linked tables may be a better solution than importing.

 

[Shannon]

I have never linked table before. What I am looking for is to get a table from one computers access to another computer access via by downloading a file into the other computers access. Will I still be able to link them? Thanks!

 

[Ken Grubb]

If this is MS Access to MS Access, linking has definite advantages. When you link Database1 to Database2, the data in Database1 remains in Database1 and the data in Database2 remains in Database2. But Database1 can view and even update the data in Database2, and vice versa. The big advantage is that you maintain ONE version of your Database1 data and ONE version of your Database2 data, not two of each.

If you want to simply move data from Database1 to Database2, then an import spec and a one time move is best.

If you're planning to keep data in Database1, but allow someone with access to Database2 to view some or all of the data in Database1, then perhaps linking would be the best solution.

To link, first open the database FROM which you'd like to link. [If your data will reside in Database1, open Database2.] Click the Tables tab, New, Link Table, and follow the Wizard.

HTH

 

[Shannon]

Will that work when there will be 10 other computers involved? I have 10 salepeoples in 10 different cities and they all have Access. Once a week I want them to send their tables to me via e-mail and I append them in one big table. Then I can run calculations and totals. I don't want them on our Network.

 

[Ken Grubb]

If all 10 salespeople had access from their PC to a network directory that you could access, then linking would work. But if you and the salespeople are 'disconnected' from one another, linking probably isn't the best idea.

If all 10 salespeople are not using the same table structure, MAKE them! That way it simplifies your life having one and only one data format.

I believe this will give you what you want. Use TransferDatabase in the code sample.
http://www.access-programmers.co.uk/ubb/Forum7/HTML/001008.html

 

[Shannon]

Thank you for all your help!