Re: Importing a CSV file into Access from Command Line

From: Karen Middleton (karenmiddleol_at_yahoo.com)
Date: 10/04/04 

Date: 4 Oct 2004 03:57:29 -0700

John Nurick <j.mapSoN.nurick@dial.pipex.com> wrote in message news:<suevl0ln7k04o1div1dcq3f9arb2mt5v93@4ax.com>...
> Yes, though I don't know how extensive the modifications may need to be.
> You may have to use ADO (the ADODB library) instead of DAO and create
> DSN-less connections before executing the queries. Also there may be
> security issues; wouldn't it be simpler on the whole to use Oracle's or
> SQL Server's own tools?
>
> On 2 Oct 2004 22:44:30 -0700, karenmiddleol@yahoo.com (Karen Middleton)
> wrote:
>
> >Sorry, I missed something is it possible to modify this code so that
> >it can import the csv file into a Oracle or a SQL Database as well.

Hi John

Many thanks for your inputs. Your help is greatly appreciated the code
you provided is cool I am able to import data into Access.

I am new to VB Scripting appreciate if somebody could provide a
similar ADO based code to import into SQL or Oracle a arbitrary CSV
delimited file.

Thanks
Karen

Relevant Pages

  • Re: Getting date/time fields from Oracle with ADO
    ... Yeah, when I 've used the SQL Plus Worksheet, the data was valid. ... I ran this code against my oracle database and it worked fine: ... CREATE TABLE "GROUPDOC2" NOT NULL, ... ado will report 135 for a date field in Oracle. ...
    (microsoft.public.vb.general.discussion)
  • Re: Oracle ADO query shows deleted records
    ... I construct a sql delete statement and fire it an Oracle ... > The short answer is no, ADO doesn't cache anything. ... > it does cache records. ...
    (microsoft.public.data.ado)
  • Re: Oracle und MS-SQL
    ... > Wenn ich über SQL QueryAnalyzer oder EnterpriseManager mir den View ... Könnte es sein dass Du einen Keyset Recordset (ADO oder ODBC) ... Der ist zwar für reinen SQL Server Zugriff längst ... sp_prepare ausgeführt und das mag den Oracle Provider verwirren. ...
    (microsoft.public.de.sqlserver)
  • Re: How to import a arbitrary CSV file from command line into SQL Server or Oracle
    ... > I have a CSV file with the first row in the CSV file to be the column ... > I want to import this file from DOS command prompt command line into ... > SQL Server or Oracle table. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to import a arbitrary CSV file from command line into SQL Server or Oracle
    ... > I have a CSV file with the first row in the CSV file to be the column ... > I want to import this file from DOS command prompt command line into ... > SQL Server or Oracle table. ...
    (microsoft.public.sqlserver.programming)