Access export to SQL Server 2005 (Cross post)

[sparkbyte]

This is a cross post from VBSCRIPT.

I need a VBscript that will query SQL2005 for the user tables in a database and then open an MDB (Access2003) file and import all matching tables.

I have an Access database that needs to be migrated to MS SQL server but it has grown so much that it is now spread across multiple MDBs.

I have the portion of the script written that will enumerate all files within a given sub folder structure, now I need to add the bit for the data import.

Any help, links, or examples would be greatly appreciated.



Thanks

John Fuhrman
faq329-6766

 

[HarleyQuinn]

Might it not be easier to drive this from the SQL Server end? Is there anything specfic that would stop you doing this through a DTS package (or SSIS package)?

Regards

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com