View Single Post
  #3 (permalink)  
Old August 27th, 2010, 08:05 AM
murshed murshed is offline
Authorized User
Join Date: Feb 2008
Location: london, , United Kingdom.
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts

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..