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
 
Back
Top