Can import from xls but what about csv???

From: Eric Lovelace (EricLovelace_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 06:51:02 -0800

Below is the query I use to import from an xls file. What about importing
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?

Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
8.0')...ChallengeResponse$

Thanks in advance,

Eric

Relevant Pages

  • RE: Collect the rows that match a list of numbers
    ... create a new query. ... Excel to the top of the query grid. ... freight numbers from the Excel table. ... a new table from the xls file.. ...
    (microsoft.public.access.queries)
  • Re: Can import from xls but what about csv???
    ... > Below is the query I use to import from an xls file. ... What about importing ... > from a csv file. ...
    (microsoft.public.sqlserver.server)
  • Dumping query result into Excel spreadsheet
    ... I want to dump the query results into a specific xls file. ... The first worksheet of this xls file has space for the query in the ...
    (comp.databases.ms-access)
  • Re: Exporting data into Excel with varying filename.xls
    ... my query creates a new filename to attempt ... DTS would automatically create the excel file with the new name and drop the ... Run once a day generating a new xls file each day. ... > and define a SQL Query for the value as you want. ...
    (microsoft.public.sqlserver.dts)
  • RE: Daily updates of Access database
    ... Have you tried creating the desired key via a passthrough query? ... > I have an access database that gets its data from AS400. ... > extracts data from AS400 and creates an XLS file. ... > know what is the best way to do daily updates. ...
    (microsoft.public.access.forms)