Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Express

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

[172 byte] By [tabwebdesign] at [2008-2-8]
«« How to read SMS from Inbox
»» a simple string-question (newbie!)
# 1

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

MarkKuether at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2

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

MarkKuether at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 3
thanks I will check it out.
tabwebdesign at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Express...
SQL Server
SQL Server Express

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified