insert excel data into sql table

**Teodor** · 07-09-2012, 06:58 AM

Hi,
I have an excel sheet with data that I would like to send to sql server.General idea is to have button on sheet which will insert data from specific row (row where cursor is in position) into sql table with same data structure.
I'm not familiar with excel programming, but have some experience in VBA for Access.
Could anybody help me?
Thanks

**Steffen Thomsen** · 07-09-2012, 07:12 AM

Hi,

Then you need to download ODBC 5.1 Driver if you havent allready, then you can use the following to connect to the database.

Please Login or Register  to view this content.

**Teodor** · 07-09-2012, 07:34 AM

Thanks,
but how I do make a query that say:
"insert into mytable(column1,column2,....) from 'row in sheet positioned by cursor'" ?

**Steffen Thomsen** · 07-09-2012, 07:42 AM

Then you would do it like this

Please Login or Register  to view this content.

**Teodor** · 07-09-2012, 07:50 AM

Thanks

Now I have diferent problem,
whe I try to run code get User-defined type not defined for "Dim c As ADODB.Connection", but in refences i did add "Microsoft ADO ext 2.8 for DDL and security"