that helps

thanks

thanks, but that just returns 0 as the result

any more ideas

thanks

simon

thank you 🙂

Simon

thanks that helps

thanks

Hi Jeff

thanks for your reply

i would want the data stored in seperate tables

thanks

Simon

Hi

Sorry for the delay

I have attached 3 sample files, its possible each one of these may be used

If the files were the same size each time i could do...

Hi thanks for that

unfortunately i still get the same error

sorry if im missing something here

can you help?

thank you

simon

Hi

i have tried using BULK INSERT

using

set @string ='BULK INSERT CSVTest FROM ''\\10.1.2.107\rp_uploaded_files\'+@file+''' WITH (FIELDTERMINATOR = '','',ROWTERMINATOR = '''')'

exec (@string)

but this requires the destintation table to have the same number...

Hi

yes im using a 64bit sever

im having trouble locating to odbc drivers for this and can only find 32bit

can you point me in the right direction

thanks

simon

Thanks for that

i seem to be getting this error

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver...

Hi thanks for that

i have tried

SELECT * into Mytable

FROM OPENROWSET (BULK '\\10.1.2.107\rp_uploaded_files\file.csv', SINGLE_CLOB) MyFile

but this puts all the data into one column and one row

what i need it for...

Hi

I think i had the wrong data like you suggested

i have changed it to

bcp "select fileoutput from [new_db]..[Invoice_Table] order by roworder" queryout c:\invoice\template\customer.html -c -T -SSQLCLUSTER -o c:\invoice\template\bcpOutput.txt

and it...

Hi

I tried as you suggested using

bcp "select fileoutput from [new_db]..[Invoice_Table] order by roworder" queryout c:\invoice\template\customer.html -c -T -SSQLCLUSTER\SSQLSERVER -o c:\invoice\template\bcpOutput.txt

but i now get the error

SQLState = 08001, NativeError =...

Hi

i have tried adding

-T

bcp "select fileoutput from [new_db]..[Invoice_Table] order by roworder" queryout c:\invoice\template\customer.html -c -o -T -SSQLCLUSTER\SSQLSERVER c:\invoice\template\bcpOutput.txt

but then i get the error

bcp: no output file specified: No...