equivalent of "load data local infile" of Mysql?
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
- From: "Casper" <c@xxxx>
- Date: Mon, 19 Mar 2007 21:07:51 +0100
Hello,
i'm looking after an equivalent T-sql command as "load data local infile
...." of Mysql, in order to import a textfile into sql server express 2005
containing data and delimited with tabs.
Thanks
Casper
.
Relevant Pages
- Re: SQL server vs mySQL ???
... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ... (microsoft.public.dotnet.framework.adonet) - RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ... (microsoft.public.sqlserver.dts) - Re: Using Mysql or SQL server as backend to Access front end
... Postgres is not compared ... The feature set of MySQL compared here is from five years ago ... Enterprise then the larger database products become a problem ... businesses will never need Oracle 10g, SQL Server or Postgres. ... (comp.databases.ms-access) - Re: Access 2007 and MySQL
... Anyone tried MySQL as backend for recent Acc2k7 FE developments? ... You can however if you want choose SQL server for your back end and then you ... For the most part most your recordset code and most queries should work as ... Set rstRecords = CurrentDb.OpenRecordset ... (comp.databases.ms-access) - Re: Newbie, True and False
... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ... (microsoft.public.sqlserver.clients) |
|