Importing few DB's to a target DB using VBA + Access modules

[Excel]

I am trying to Automate the loading of 10 databases to a target database using VBA and Access modules.I have no idea how I should write that code!!!( All the source databases and the Target database have the same structure)
I would really appreciate it if any one can give me soem hints regarding the script....
Thanks so much,,,,

 

[Rohdem]

Why don't you just link to their tables?
Mike Rohde
rohdem@marshallengines.com

 

[MichaelRed]

The topic heading mentions "Excel". To import Excel Spreadsheets, look up the transferSpreadsheet function. For 'other' Ms. Access database Tables, Look at the "TansferDatabase" method.

If this is a one shot consolidation, It is not worth the effort to set up a module/code for just 10 databases. Do It manually from the file/external/import menu. If it is an ongoing/repetive process, reply to htis thread w/ some details and I'll set up a skeleton which you can use. At least provide the names and object types you need to import, and hopefully a sample of the data.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over