[SQL Serevr 2005 Express] Loading data from an Excel sheet

Hi,

Is it possible to load data from an Excel sheet column, into a DB column within SQL Server Express Edition? I'm able to copy data from the DB talbe column into the Excel sheet, but not the other way, which forces me to enter data row by row, manually.

Thanks,

Alon

I describe one way I can do:

Create your table with the datastructure you want from VWD IDE for your batabase in the App_Data folder.

1.Select data from your excel columns and copy.

2.Open your table, highlight one blank row, right-click the highlighted area, from the manu select paste.

You already know how to copy data from SQL2005 Express to excel. It is sort of the same thing.

You may need to watch your column datatype.

|||

Hi limno,

Thanks for the detailed answer.

I tried it before, but unfortunately VWD doesn't support Paste of multiple cells. This means that if you'll copy several cells (within 1 column) from the Excel sheet, and try to paste it in the DB table (in VWD), as you described in step #2, you'll notice that only 1 cell, the one you highlighted, is affected.

This is, unless I'm missing something very basic...

Thanks,

Alon

|||

You paste over the highlighted row. That means all clomns in your table are highlighted.

If you highlight only one cell, it is true that everything goes in that cell.

Hope this helps.