Re: Ignoring duplicates in BULK INSERT with ADO and SQL Server 200

Hi Stephen,

I am using bulk insert to transfer hugh data from a .dbf file to my sql
server table.

Then I assume that you have the DBF data saved as a file that is accessable
from SQL Server.
Because for SQL Server to do BULK INSERT that is what it demands.

Can you guide me in this case what shoud I specify as
fieldterminator and rowterminator?

By default fieldterminator should be the tab character and rowterminator
should be the newline character. But these can be changed in the BULK INSERT
statement as clauses.

Stephen Howe


.

Relevant Pages

  • Re: VBA - Create a recordset with no records for inserting
    ... directly into the server, I can run a PROC that gets files from my desktop. ... The ServiceBroker will construct the dynamic SQL statement to BULK INSERT the ...
    (microsoft.public.data.ado)
  • ANN: CsvReader 2.0 Released
    ... One of the most common tasks involving CSV data in a Microsoft ... environment is to bulk insert data originating from a CSV file into SQL ... another datasource directly into SQL Server at almost DTS speeds. ...
    (microsoft.public.dotnet.general)
  • Re: Create DBF
    ... Using SQL 2K will require too many other variables into the ... >> recreate a DBF file on device, only to have to move it to the server. ... >>> have access to the code for this server app. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Create DBF
    ... and retail apps to WinCe/PPC, ... recreate a DBF file on device, only to have to move it to the server. ... Why not sych your SQL CE data to SQL Server 2000 using RDA ...
    (microsoft.public.dotnet.framework.compactframework)
  • Import mit Bulk Insert Probleme mit Umlauten
    ... Ich bin mit meiner Applikation von SQL 2000 Server auf SQL 2005 Server ... Jetzt habe ich mit den Bulk Inserts mein Problem ... In der zu importierenden Textdatei stehen die Umlaute korrekt ...
    (microsoft.public.de.sqlserver)