Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Transferring data from text file to sqlserver

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-12 : 08:53:34
Mohan writes "Hi Everybody,
I have a problem here.Iam trying to transfer data from informix into sqlserver. I have the data in informix in an excel file . So i wanted to know if there is any function in sqlserver where i can read the data from excel and insert the values into my table in the sqlserver2000 database.

Rgds,
Mohan"

smccreadie
Aged Yak Warrior

505 Posts

Posted - 2002-11-12 : 09:20:20
You can use DTS to import from an Excel file. Alternatively, with the correct Informix ODBC driver (Merant makes one), you can import directly from Informix.

Go to Top of Page
   

- Advertisement -