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

BubbleGum

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
Glen Bartlett

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
A-Ka
thanks I will check it out.
import tool

Answer this question