LOAD INFILE

[doddo]

Hi, i usually use MySQL and import data into tables that I have using the following statement:

LOAD INFILE 'TOTALregistrationss.CSV' INTO TABLE users

This doesn't appear to work with the MS SQL db that I have been forced to use.

I was wondering whether any other MySQL users had been forced to use MS SQL and knew of another way of importing data?
I do not have SQL enterprise manager, all I have access to is something called Qtado which is a universal querying tool that this guy sells for a couple of pounds. We are renting space on our hosts SQL server.

Any help would be greatly appreciated,

Rich

 

[leefriend]

Very similar to MySQL, MS SQL uses isql as a command line utility for general SQL manipulation. However, if you want to import data then you are best to use the bcp utility. I'm not 100% sure if you need the client tools installed on your local pc though? Search Microsoft's Knowledgebase web site for bcp, there should be a listing of the switches etc to use there.
Good luck.
Lee.