Hi Prakash, thanks for your reply.

Yes, it is a one-time transfer of data over to the website back-end. My problem is further complicated by the fact that I'm working with SQL Server Express and have no access to a stand alone program for importing/exporting data in SQL Server Express.

I read in several places about this import wizard but I just don't seem to have it as part of my install. I have a couple of SQL Server 2005 tools installed, the Surface area configuration manager and the Server configuration manager, neither of which provides an avenue for importing data into a table.


is there some programmatic way in which I could read data from the spreadsheet and INSERT into the table columns?