export data to SQL server

[Sarah G.]

I'm trying to export an excel file to SQL server. Right now what I did is
that export the excel data into access, and in access run query to export to
sql.
Not sure how to do this directly to sql server from excel to sql table.
for example:
excel file:

customer# | custname | sales|

SQL table
customer# | custname |sales|

Thanks,
Sarah

 

[Frank Kabel]

Hi Sarah
I would do this the other way round:
- IMPORT the file from SQL Server
- Not sure about the SQL Server (normally use Oracle) but it should at
least be able to import csv files. Maybe also Excel files directly 8if
MS supports its own products...)

 

[Sarah G.]

Frank,

Thank you for your reply. I give the wrong info. Actually I need to
reorganize the excel data and then import into sql server. the columns could
be different. I know how to use script to reorganize into an access
database, but not sql server table. so I have to do a few steps to
accomplish it.
Sarah

 

[onedaywhen]

Post your existing script/code and someone will be able to suggest an
alternative approach which doesn't use MS Access.

--