important Excel to SQL server

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 12

important Excel to SQL server

Hi,
I have one excel file with following structure.

Table1(with 5 columns) from row 0 to row 10

Table2(with 10 columns) from row 12 to row 21

Table3(with 3 columns) from row 23 to row 50

i want to insert this tables to my database tables.

how can i achieve in fastest way.I tried using looping thru excel
application object.but very slow.

please any ideas to achieve this.

thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
What are the most important Excel concepts I should know (will be tested soon)?	DonaldCX	Excel Discussion (Misc queries)	5	May 4th 23 07:41 PM
Help! I can not remember the password to an important Excel workb	burningmeteorite	Excel Worksheet Functions	8	May 15th 08 07:06 PM
What are the most important Excel concepts I should know (will be tested soon)?	DonaldCX	Excel Discussion (Misc queries)	1	April 21st 06 02:05 AM
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server	Seabee	Excel Discussion (Misc queries)	0	November 20th 05 12:03 AM
important day today utilities of EXCEL	wajeed	Excel Discussion (Misc queries)	1	April 12th 05 02:58 PM

All times are GMT +1. The time now is 07:06 PM.

Menu

About Us