BCP Question 1

[Denaeghel]

Is it possible to import data from Access into SQL-Tables with BCP.

Now I do it with DTS, but the combination of SQL Server 7, Windows 2000 and ADO gives me problems with scheduled tasks (bug in SQL Server 7). See

http://support.microsoft.com/default.aspx?scid=kb;en-us;255900

Thanks in advanced

Karel

karel.denaeghel@barco.com

 

[JamesLean]

No, BCP can only be used to import/export data to/from flat text files.
You could look at setting up a linked server and importing the data using a simple INSERT statement. --James