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 |
|
2revup
Posting Yak Master
112 Posts |
 Posted - 2011-12-04 : 05:14:18
|
| Hi Guys, I can easily do an export from MDB into SQL, there is also info everywhere for this, but I can find any where or way to do this via TSQL. I can export data from SQL to the access database using the import / export function and then create an SSIS package however, this is not good to me. I am working with an express edition of SQL so SSIS does not exsit.I need to do the same thing as the export if doing but in a T-SQL format. The export is rather easy.1 Table in SQL is a 1 to one mapping to MDBTable 1 in SQL = Cat_ProductImportTable 1 in MDB = itemsIf anyone is able to offer some assistance with this I would be eternally grateful. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-04 : 05:18:35
|
| see OPENROWSEThttp://msdn.microsoft.com/en-us/library/aa276850(v=sql.80).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
TSQL export to MDB