Excel and SQL Server

[malladisk]

Hi!
I have an excel spreadsheet from which I'd like to export data into SQL Server and vice versa. Anyone knows how to do it? I know this is a very generic question with no easy answer but any help in pointing me in the right direction is appreciated.
thanks,
Sashi

 

[tlbroadbent]

Which version of SQL Server are you running? Transferring data between SQL Server and Excel is very easy in SQL 7 and 2000. Simply use Data Transformation Services (DTS). You can use the DTS Import/Export to create the transfer package.

With earlier SQL versions, you would need to use intermediate text files, exporting to text from SQL and then importing the file to Excel or exporting from Excel and importing to SQL. You could also use the MS Access TransferSpreadsheet action or method with linked SQL tables and Excel workbooks.

In any case, it is really not hard at all. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[malladisk]

Hi, Terry!
Thanks a lot for your help. I think this will make life easy for me!
One more thing, though. I'm using 2000 so that's ok but I'm using Excel 97, not 2000. Would this still work? I mean, both exporting and imorting. And I can't migrate to Excel 2000 since I'm using a tool built with Excel 97.
Thanks,
Sashi

 

[tlbroadbent]

No problem. Import/Export with Excel 97 is supported. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[doddo]

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

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.

So, I read with interest your earlier discussions. Where are the DTS's? 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