Posted to microsoft.public.excel.programming

DennisB[_2_] DennisB[_2_] is offline

external usenet poster

Posts: 9

import Excel worksheet to SQL Server table

I have an ADO connection to SQL Server 2005 and I use SQL Server Management
Studio's import wizard to import Excel sheets to tables. This is very time
consuming and I was wondering what would be the best way to import the files
to SQL using VBA from Excel. I currently call various stored procedures from
VBA.

Any code snippets or help?

DennisB

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Excel Data to SQL Server	ryu[_7_]	Excel Programming	1	August 5th 09 11:26 AM
import data into SQL Server from Excel	Rachel[_2_]	Excel Discussion (Misc queries)	1	October 27th 08 02:35 AM
Import data from MS Sql Server to Excel	mesarim	Excel Programming	1	October 29th 07 05:31 PM
how to import an excel table into sql server express?	Ben	Excel Programming	1	July 4th 07 06:39 AM
import and export from SQL SERVER to Excel	sal21[_106_]	Excel Programming	1	June 14th 06 10:56 AM

All times are GMT +1. The time now is 01:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us