SQL on csv files?

  • Thread starter Thread starter guy
  • Start date Start date
G

guy

My application creates csv files locally and uses MSAccess as sql engine. This is working well but I
want to use SQL Server instead. One way to accomplish this would be to use a bulk insert into
temporary tables but SQL Server would need access to the csv file system.

Is there any other method?
 
Hi Bill,

I saw you had a message at 4:42 and than 12:22 my time, however it was 5:30
and not 4.

There once was a message from Terry (OHM), asking me if I ever did sleep,
however you beat me.

I never saw you intended do something wrong and when I saw you did make a
mistake I would tell what one, what I suspect you would do to me as well.

Mistakes are to learn from, however had nothing to do with it.

:-)

Cor
 
If the schema stays the same, then youcan just use the .csv data provider of
ADO.NET - check out www.connectionstrings.com
Click to expand...

Using the .csv data provider of ADO.NET will do for a single file. It gets more complicated when I
need to join multiple files in a query and specify data types for some columns. I can manage the
schema.ini on the client.

Is it possible to use a join query with the .csv data provider?
 
Back
Top