Re: How to import a tab delimited text file into MS Access database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you file has any indication of which data goes in which field you could
just parse the CSV file and update the records one by one to the .MDB file
using:

http://msdn2.microsoft.com/en-gb/library/34fa51ss(vs.71,en-us).aspx

Tom

"Pradeep" <pradeep.ram@xxxxxxxxx> wrote in message
news:1163809911.714407.230170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have the following task to be done in VC++ 6.0. I have a tab
delimited text file that needs to be imported into a MS Access table.
The table is created and the table structure is defined using DAO
methods. So now I have to fill this table with the data in the text
files. For a few rows in the text file, the number of columns could be
less than the number of columns in the table. Can anyone please post me
the code to do this. Thanks a ton in advance.

Pradeep



.

Relevant Pages

  • [OT] Bash Script Help
    ... I am writing a shell script to parse a CSV file to prepare it for ... the CSV file looks like this: ... Can I use command substitution in a sed substitute command? ...
    (Debian-User)
  • Import Files to Excel File
    ... PDI Number: GEN000240 ... Finding Category: CAT I ... I want to parse over 300 of these into a single excel or csv file. ... I was thinking to do a forloop thru the files and then parse the files via each field to the csv. ...
    (perl.beginners)
  • Re: Simple XML-to-Python conversion
    ... > If I used a simple INI file or CSV file, I would simply have to parse ... > parse a document once and then re-parse your information into a format ... A configuration file is only ...
    (comp.lang.python)
  • Unrecoverable error 332 string/array memory overflow
    ... During a .csv import from a fairly big .csv file, and ... place the fields in that cLine into an array and then AADDing that ... in a variety of places during the 'parse' loop ... To forestall this crash I put in a delay of 4 seconds after reaching ...
    (comp.lang.clipper)
  • RE: Problem with SMS SP1
    ... A good starting point would be to parse the smssetup.log file as that could ... show an indication as to why the service pack failed. ... Get Secure! ... When responding to posts, ...
    (microsoft.public.sms.admin)