Re: Databases - Beginner's Question

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 07:33:27 -0500

At the risk of ruffling ole Ben's feathers again, I will point out that ADO can open a csv file and extract data via SQL.

         cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & PathThCSV & ";" & _
                               "Extended Properties=""text;HDR=Yes;FMT=Delimited"""
         cn.Open

The csv can be queried now using standard SLQ statements.

That having been said, I find no advantage to maintaining a flat file over a database unless it is read only and relatively small
AND you do not want to add the dependency on MDAC. 

--
Al Reid
"It ain't what you don't know that gets you into trouble. It's what you know
for sure that just ain't so."  --- Mark Twain
"Bonj" <a@b.com> wrote in message news:enDlPd##DHA.2336@TK2MSFTNGP11.phx.gbl...
>
> > What would be the benefit in going to a database rather than a text file
> (CSV)?
>
> Main one being that you can extract data via SQL.
>
> >
> > Also, can anyone recommend any good websites that have any kind of
> tutorial information regarding
> > database creation and retrieval from VB?  I've never messed with any kind
> of database in VB before
> > (although I'm a little familiar with MS Access as far as creating a simple
> database from there).
>
> Get a book on SQL, get a database (MSDE is a good option - free to download
> from MS) and spend a few hours with the two together.
>
> >
> > Thanks
> >
> > Tim
> >
> >
>
>

Relevant Pages

  • Re: transfer data into an external database
    ... >With regards to your SQL code I have no idea about SQL. ... If there is a schema.ini in the same folder as the CSV file, ... >> Create a Schema.ini file based on an existing table in your database: ... John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: transfer data into an external database
    ... With regards to your SQL code I have no idea about SQL. ... > Create a Schema.ini file based on an existing table in your database: ... >>import a csv file using an import specification. ... >>reference to BigTables.mdb into Control.mdb ...
    (microsoft.public.access.externaldata)
  • Re: Create a binary database from VBA
    ... banned MDB as a reliable database format and instead proposed Oracle and SQL ... i didn't tougth about writing to a csv file, good idea but i was thinking ... that for anything except trivial amounts of data the VBA engine will be ...
    (microsoft.public.office.developer.vba)
  • Re: Read CSV to SQL
    ... > Does anyone have an example of how to read a .csv file into a SQL ... > database with an ASP? ... Alternatively, with SQL 7 and above, there is a T-SQL command called "Bulk ... Insert" which can be called from asp just as any other query would be ...
    (microsoft.public.inetserver.asp.db)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)