Problem Importing Data from Excel To SQL

  • Thread starter Thread starter Faizal Tan
  • Start date Start date
F

Faizal Tan

Hi there can anyone tell me how i can import the data from an excel sheet to
an SQL table WHILE ignoring the sheet name or uploads wether or not the
sheet name is the same or not. Right now i have to make all sheet names to
be Uniform or else i get an error uploading a sheet with a different name.


Rgrds
Faizal
 
Hi Faizal,

Can you give us some more information?
How are you importing from Excel to SQl Server?

DTS Package? ADO? Excel VBA?

Ed Ferrero
 
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

Excel 2010 Table not showing in Access 2010 Import List 0
Auto data entry 2
Segregate Outstanding Payment 1
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Copy Data from One sheet to Different Sheets 1
Excel Move or Copy Stopped Working? 0
Imbedded Data Input sheet 3

Back
Top