Data From Excel to Sql

  • Thread starter Thread starter pushpendra vats
  • Start date Start date
P

pushpendra vats

Hi!!
I have a small problem...
I have data in excel and want to excess it convert into
sql table with certain validations .How to do it...
Any help..

Thanks

Pushpendra
 
Hi Pushpendra,

I think you can start to read it in a dataset, however than you are not
ready.

Because you do not know what is in your excel file on doubles, new etc, you
have to process it.

That can be in a lot of ways depending on your, however I think for that is
the simplest way looping through your excel dataset.

A connectionstring you find for that here

www.connectionstrings.com

Cor
 
Hi Ken,

It was no critique, only to attent you on this

Transfer Data * to* an Excel Workbook by Using Visual..................

Cor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data From Excel to SQL 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
What are the steps to fix damaged MDF files in SQL Server? 0
VBA - retrieve data on last create named range from previous inserted named range 0
Example Of VBA SQL Statement 0
saving on screen data to comma delimetted text file 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
SQL script to solve problem 1

Back
Top