MSSQL 2005 - Data Import

[tomfloate]

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]

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]

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

 

[tomfloate]

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

 

[hafa]

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.