How to read CSV File in SQL Server 2005 using OpenRowSet Function

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi

i want to access a CSV file using OpenRowSet function in SQL Server
2005.



Anyone having any idea; would be of great help.

Regards,

Salman Shehbaz.

.

Relevant Pages

  • Re: How to read CSV File in SQL Server 2005 using OpenRowSet Function
    ... i want to access a CSV file using OpenRowSet function in SQL Server ... Salman Shehbaz. ...
    (microsoft.public.sqlserver)
  • Re: MDX Query results Inserted into SQL table
    ... Put the MDX query in the following SELECT statement. ... represents the name of the SQL Server 2005 Analysis ... The provider name in the OpenRowset function is specified to be ... AllowInProcess registry entry is MSOLAPTEMP, ...
    (microsoft.public.sqlserver.olap)
  • Import data with a package variable to SQL destination
    ... I need to import a bunch of csv files into one sql server table using SQL Server Integration Services. ... Each csv file contains price data for a financial market. ... The csv file headings are Date, Time, Open, High, Low, Close but no market code. ... As each file is a different market, what I want to do is create a variable and set the variable to the market code for each import that I do. ...
    (microsoft.public.sqlserver.dts)
  • Forms help
    ... I have a macro that imports a CSV file and then queries a SQL Server ... database using criteria from the rows in the CSV file. ...
    (microsoft.public.excel.programming)
  • Re: Exporting and Importing Data
    ... When you are setting up your Flat File connection manager to the csv file you are given the opportunity to review/change/suggest datatypes and lengths for the columns. ... SQL Server Integration Services is the new name for DTS and it is a whole different beast. ...
    (microsoft.public.sqlserver.dts)