exporting access tables

[koolguy]

hi all,

can anyone let me know if its possible to export all my tables from ms-access to Microsoft SQl Server??????


Any help would be much appreciated!

 

[pbaldy]

Sure; one way would be the Upsizing wizard. You would first need to set up a DSN.

 

[DCrake]

Simple Software Solutions

Open up SQL server Enterprise Manager and use the import wizard

 

[DCrake]

Simple Software Solutions

Do you have any experience with MS SQL Server? If not find someone from your IT support team or systems administrator to show you. It is far easier to use the wizards if you can see it in action. trying to talk you though it would be difficult.

Tell me, and I'll forget;
Show me, and I may remember;
Involve me, and I'll understand.


CodeMaster: