Wednesday, March 7, 2012

BULK INSERT and Access2000 data

Hi there,
Is it possible to use BULK INSERT to import data from an Access2000 table to an SQL Server table?
Thanks in advance.BULK INSERT works with SQL Server and use DTS to import data from Access database.|||Originally posted by Satya
BULK INSERT works with SQL Server and use DTS to import data from Access database.

I know that you can use DTS! That's what I've been using all the time but I am interested to know whether it is possible to do it in T-SQL instead.

Thanks for your suggestion though!|||I've done it if the Excel is saved as a CSV file.

No comments:

Post a Comment