Hi, does anybody know how to perfor

[doddo]

Hi, does anybody know how to perform the following MySQL statement in MS SQL?

LOAD INFILE 'TOTALregistrationss.xls' INTO TABLE users

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

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

 

[Bernadette]

Hi There

Why not use DTS in Sql Server to get the job done. You can set up the Excel spreadsheet as a source and the database as a destination. You can even save the DTS job in SQL Server so you only have to execute it if you want to run it again.

Check out DTS in BOL.

Here are some sites you can check out too.

DTS Data Import-export

http://www.microsoft.com/technet/tr.../TechNet/prodtechnol/sql/maintain/dataimp.asp

DTS How to

http://www.swynk.com/friends/green/DTSHowTo.asp

Hope This Helps
Bernadette

 

[doddo]

hi,
thanks very much. The thing is I don't have access to the server as we're renting space on it, therefore I don't think I have access to DTS, I may be wrong though?
I am using a univeral tool called Qtado, which is similar to SQL enterprise manager but can be used for any DB
I have a table already created on the server with data in it. I want to import the extra data from the spreadsheet into the table.
Thanks for the links, very useful. It looks as though BCP may be better for me as I don't have the Enterprise manager

cheers
Rich

 

[Bernadette]

How about checking out Bulk Insert in BOL. Bernadette