Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
genius_palli
Starting Member
42 Posts |
 Posted - 2009-12-04 : 04:30:42
|
| Hello friends..I have an MS-ACCESS file(.mdb extension). Is this possible to create all the tables in SQL SERVER which are in MS-ACCESS file programmatically. And I need to copy data as well from MS-ACCESS file to the created tables in SQL SERVER.I can access the data in MS-ACCESS tables using a Linked Server, but I want to create all the tables in SQL Server which are in MS-ACCESS.Please help. Regards-- genius_palliRegardsgenius_palli |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-04 : 08:17:34
|
| Right click the database you want the Access tables to go in, choose All Tasks, then Import Data. Choose Microsoft Access as the data source...then check all the tables you want to import |
 |
|
|
|
|
|
Microsoft Access dbase to SQL Server dbase