June 6, 2006 at 9:50 am
Ok. I am new to all of this so please be patient. I am creating a website with VWD and sqlexpress. My client sent me an excel spreadsheet with over 800 rows in it and I need to somehow get that data from the spreadsheet into my sql database. How do I do that?
And why does this stupid thing tell me that it can't generate a user instance? This happens every time I shut down my computer. I end up trashing the sqlexpress folder and having to restart again in order to connect to the database. I found lengthy threads on this on microsoft's site but nobody actually answered the question.
I am running on windows xp, by the way, not windows xp professional.
June 6, 2006 at 10:33 am
I would create a linked server if i was using sqlexpress.
You can add them by in the express management studio or by using some system stored procedures i don't believe its in the express docs so
http://msdn2.microsoft.com/en-us/library/ms175866(SQL.90).aspx
hth
David
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply