Hi Jeff,

Yes I will most definately let you know how long it takes. I am going to start on it tonight.

Hi Jeff,

Thanks for your continued interest. I am reassured by the term "staging table". It suggests that this technique is used quite often when importing data.

To give you more information,...

Hi Jeff,

Thanks for your feedback.

I am at the point where I need to make a decision. I have 2 choices:

1. Use bulk insert - However I need to run...

Ok I got a solution:

INSERT INTO

xTest2

(Numeric1,Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8)

SELECT

Numeric1,Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8

FROM OPENROWSET ('MSDASQL','Driver={Microsoft Text Driver...

Hi Jeff,

I managed to get the OPENROWSET to work using the following

SELECT *

FROM OPENROWSET

('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Files\CSV','SELECT * FROM example3.csv')

How do I adjust the above script to copy...

Hi Jeff,

Thanks for this. I have never come across this method before and this does look promising.

I have a few questions if you would kindly respond to:

1. I am using...

Since my last post I have figured out that I could use a format file.

Here is another example CSV file which better illustrates what I am referring to:

---------------------------

ID,TextField1,TextField2

23,This is some...