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?
Last edited by murshed; August 27th, 2010 at 01:18 PM..