Re: SQL-Server nach dBase
From: Douglas Laudenschlager [MS] (douglasl_at_online.microsoft.com)
Date: 07/08/04
- Next message: Bert Sachs: "Re: Best practices - typed vs. untyped DataSets, DALs etc.?"
- Previous message: Bert Sachs: "Re: Best practices - typed vs. untyped DataSets, DALs etc.?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Jul 2004 13:19:33 -0700
The syntax that you are using is supported only by the Microsoft Jet OLE DB
Provider. Although you do not show us your connection code, I suspect that
you are using SQLClient or SQLOLEDB. If you want to use this syntax of the
Jet Provider, the easiest solution would be to create an Access database
that contains your SQL Server View as a "linked table," then use the Jet
Provider to connect to the Access database and export the data from SQL to
dBase.
Another solution would be to create your dBase file as a "linked server" in
SQL Server, then use SQL syntax over a SQLClient connection to SELECT INTO
the linked server.
As the Jet ISAM drivers all behave in a similar manner, you can search the
Knowledge Base for how-to articles about the more frequently used ISAM
drivers (especially for Excel), and much of that information will also be
true of the dBase driver.
-Doug
"news.bluewin.ch" <daniel.zinniker@bluewin.ch> wrote in message
news:O9RgeIeXEHA.4092@TK2MSFTNGP11.phx.gbl...
> Hallo NG
>
> ich habe ein Problem mit einem Datenexport.
> Ich verwendet einen SQL-Server und habe einen View welcher die zu
> exportierenden Daten enthält.
>
> Wie kann ich am einfachsten eine dbf-Datei mit dem gesammten Inhalt der
View
> erstellen ?
>
> Folgender ansatz hat leider fehlgelschlagen:
> cmd.Connection.Open();
>
> cmd.CommandText="SELECT * INTO export IN 'e:\\' 'dBase III;' FROM
> tm_exportdata ";
>
> cmd.ExecuteNonQuery();
>
> cmd.Connection.Close();
>
>
- Next message: Bert Sachs: "Re: Best practices - typed vs. untyped DataSets, DALs etc.?"
- Previous message: Bert Sachs: "Re: Best practices - typed vs. untyped DataSets, DALs etc.?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
