How to create Table from excel without using OLEDB

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

General SQL Server Forums

New to SQL Server Programming

How to create Table from excel without using OLEDB

Author

Topic

binto
Yak Posting Veteran

59 Posts

Posted - 2011-04-14 : 06:24:54

Hi,

Please provide a solution for creating Table and inserting data to table from excel having multiple sheets without using OLEDB.

Thanks,
Binto Thomas

Thanks & Regards
Binto Thomas

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-14 : 07:37:37

Why can't you use OLEDB? The easiest way to do this is to use Integration Services.

binto
Yak Posting Veteran

59 Posts

Posted - 2011-04-14 : 08:02:47

Hi,
I am getting error for version conflict in different servers.
I have a web application which is used for entering data from excel(multiple sheets having about 200000 rows) to SQL DB.I am doing using the following steps

1) Convert excel to byte and get the sheet name and save both in DB using OLEDB
2) Take byte data and sheet name from DB and create an excel in server and convert byte to orginal dta with keeping sheet names.

3) Insert excel data to table using OLEDB,Getting some error due to OLEDB version conflict.

Please help me to solve the issue

Thanks,
Binto Thomas

quote:
Originally posted by robvolk

Why can't you use OLEDB? The easiest way to do this is to use Integration Services.

Thanks & Regards
Binto Thomas

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources