Merging 4 databases together

[maggotdrowner]

Could anyone explain (or point me in the right direction) how to join 4 different files together to create just one big file???

I have 2 x WORKS DATABASE and 2 x ACCESS 2002

They all open and can be worked on but I would like them as one file.

Many thanks

 

[Ken Snell]

Export the data from the Works databases as csv files. Import those text
"csv" files into ACCESS database.

Import tables from one ACCESS database to another (in ACCESS, File | Get
External Data | Import).

--

Ken Snell
<MS ACCESS MVP>

Could anyone explain (or point me in the right direction) how to join 4

different files together to create just one big file???

 

[maggotdrowner]

Thanks for the reply...but tried that and it doesnt work.

I have 700+ files on one and the same on the other, and I want to just put them together so I have one file of 1400+

then I have another file to add with about 2400+

I cant even get them to merge the two 700's

I've followed what you've shown below but after the import objects window,selected which file to import, clicking ok..... Nothing happens but the window closes and leaves
me with the file I started with.

Please tell me it's just me doing something wrong (and what it is)

Many Thank Again

 

[Ken Snell]

Very difficult to advise further without more detailed information.
Importing data into ACCESS is a relatively normal operation, so your
difficulties must be related to something in your files' structure or your
setup?

Tell us what steps you're taking.
--

Ken Snell
<MS ACCESS MVP>

Thanks for the reply...but tried that and it doesnt work.

I have 700+ files on one and the same on the other, and I want to just put

them together so I have one file of 1400+

then I have another file to add with about 2400+

I cant even get them to merge the two 700's

I've followed what you've shown below but after the import objects

window,selected which file to import, clicking ok..... Nothing happens but
the window closes and leaves

me with the file I started with.

Please tell me it's just me doing something wrong (and what it is)

Many Thank Again