-
Running a SQL query using a CSV file
Im looking to help automate a manual process right..
We have our payroll department that still running on foxpro db.. they are
able to export data out in cvs format.. and that has helped in the past
populate our other system by using the bulk insert with those files...
Is there a way to accept a CSV file as part of a query to provide our
payroll department a report / results that they can work off of?
--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
-
Re: Running a SQL query using a CSV file
>> Is there a way to accept a CSV file as part of a query to provide our payroll department a report / results that they can work off of? <<
Why not BCP it into a table and then write whatever you need to do the
job?
-
Re: Running a SQL query using a CSV file
If thats the case, could we not use the Bulk Insert to create a table with
those values and schedule it so they can dump the file in during the day and
the next day come in and have a report waiting for them?
--
ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
"--CELKO--" wrote in message
news:ecbf3bf1-cd43-4dd7-a508-e0f6958a0ccf@b1g2000hsg.googlegroups.com...
>>> Is there a way to accept a CSV file as part of a query to provide our
>>> payroll department a report / results that they can work off of? <<
>
> Why not BCP it into a table and then write whatever you need to do the
> job?
-
Re: Running a SQL query using a CSV file
You can do that with OPENROWSET. It's even more powerful in SQL2005. Look
it up in Books Online (BOL) or post back if you get stuck.
HTH
wBob
"Daniel" wrote:
> If thats the case, could we not use the Bulk Insert to create a table with
> those values and schedule it so they can dump the file in during the day and
> the next day come in and have a report waiting for them?
>
> --
> ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008
> "--CELKO--" wrote in message
> news:ecbf3bf1-cd43-4dd7-a508-e0f6958a0ccf@b1g2000hsg.googlegroups.com...
> >>> Is there a way to accept a CSV file as part of a query to provide our
> >>> payroll department a report / results that they can work off of? <<
> >
> > Why not BCP it into a table and then write whatever you need to do the
> > job?
>
>
>
