Data from excel to sql server 2005

Is there a good site with example code for getting data from excel to sql server 2005....

kaak

It may be better to look for SQL forums of newsgroups to ask your question as likely they would be more likely to control this process.

If I were needing to do this however, I would be attacking this as an import from Excel from inside SQL. I only use SQL 2000 so use the old DTS route which was easy, this has now changed in 2005, but shouldn't be too tricky.

Maybe if you actually detail what you are trying to do, someone may be able to help here. (and if not, you can just cut and paste it to another forum)

Nick Hodge:

Maybe if you actually detail what you are trying to do, someone may be able to help here. (and if not, you can just cut and paste it to another forum)

Spot on. Without any details the only advice I could give is that there are hundreds of ways to do this of which two or three would be appropriate for any given circumstance.

Cheers

I'm importing data files into excel ( csv, txt and xml) and combining and modifying them.

After some checks I want to write some of the data to an sql server 2005 database.

Currently I'm using a linked access database but not proud of myself

Hi,

Exporting data from Excel to a SQL Server 2005 includes:

• Make sure that all data is well formated in the source worksheet(s)
• Creating the connection string
• Creating the SQL statement
• Create the VBA code, including which db library to use (DAO or ADO)

Or, as Nick alluded to, why not use an SSIS task (2005's replacement for DTS) to import the data? In fact, I would imagine that you could cut the Excel (and Access) stages out altogether and get the data directly from your CSV files, performing the necessary filters & transformations along the way.