Import Excel table

How to import Excel table to MSDE
Hi,
I am not sure if this is the best/right way.
But in EXCEL workbook you can use VBA and write code to transfer the data
using ADO. Use Tools/References and select the Microsoft ActiveX Data objects.
You can also just write a small vb app.
you have multiple options.
Case 1. Create DSN for Excel file and DSN for MSDE database
then use them as the source and destination and transfer the data
Case 2. Save the Excel file as a CSV and use it as source
Case 3. Using VBA in Excel write a small code to go through all the rows and
create a Query file. Which you can use with OSQL -i to execute and transfer
data.
I hope it helps.
"Nikolay Petrov" wrote:

> How to import Excel table to MSDE
>
>