import tool

I was looking for an import tool that will import text, excel and access files into sql server express Does anyone have any suggestions

Thanks

Tom

Answer this question

import tool

sk4130

Tom,

I'd like to import a .csv file as well. Do you know for certain that studio express doesn't have the ability I can't find it or references, so I just don't know if I'm looking in the wrong place or it can't do it.

Have you found documentation stating that it can't

Mark Kuether
rohangopal
thanks I will check it out.
Spiderlogic

Tom,

There is a tool do to this called bcp. It's and exe in the c:\p.f.\ms sql srv\90\tools\binn directory. If you look on the Sql Server > Sql Express forum, you'll find references to using the tool.

Mark
import tool

Answer this question