Exporting MS access data in to SQL Server

[shanuragu]

Hi
How can export MS Access data in to SQL Server???


shara

[Khalid Ali]

Typically a reasoable database program will have a built in utility which you can use to get a dump file for export purposes.(I have used oracle and MySQL,both allow you to get dump files).
As for access database,I know it has a built in program that allows you to export or import databases using odbc link from other databases.I am positive
SQL serve do have something like this,just cosult the help files

[hussarweb]

have a look for the option to upsize the database i think this exports it all for MS-SQL Server