MSSQL 2005 - Data Import

tomfloate · October 31, 2007, 10:24am

Hi, what is the best wawy to do a Data Import in 2005 with Jodo? I cannot connect through Enterprise Manager and need to do an Import from a CSV file? I have looked at the MSSQSL Manager but to no avail.

Thanks
Tom

tomfloate · October 31, 2007, 2:46pm

Has nobody else tried to do this? Someboyd must have needed to do a data import to a SQL 2005 DB hosted on Jodo.

Stephen · October 31, 2007, 3:36pm

Importing from a CSV file will require bulk admin access will it not? We don’t allow that

tomfloate · October 31, 2007, 5:18pm

okay , thanks for the info stephen. I will write a little app instead to import.

hafa · November 1, 2007, 3:19pm

I use MSSQL studio 2005 to do imports from Excel all of the time. Right click the DB, go to tasks>import and run the wizard; works like a charm.
If you don’t have MSSQL studio 2005, I’d be willing to bet that you can do the same thing with the free MSSQL server 2005 Express Edition.