Need help importing a large csv file

  • Thread starter Thread starter DustJunky
  • Start date Start date
D

DustJunky

I have a csv file around 80 MB in size with thousands of records. It came from a
very old DOS program that cannot export in any other format and I need to
somehow get the data into Access 2002. Whatever I try, it seems to crash Access.
I am not really familiar with Access though I know my way around computers. Can
anyone suggest a method for importing this file or suggest a third party
converter that will make a csv into a mdb file.
 
What is a sample of a single data record? You're saying ACCESS crashed when
you tried to import the file using File | Get External Data | Import method?
 
It's a database of archived backup disks. It has only 5 fields comprising
filename, file path, date created, date modified and backup disk number all text
fields but the number of records is huge. Excel opens part of the csv file
presumably until it runs out of space in a workbook but in access from File |
Get External Data | and either import or link table it just sits with no error
until windows XP auto-closes it for not responding
 
Try using a macro with the TransferText action to import the text file
directly. Do not use an EXCEL file as an inbetween process.
--

Ken Snell
<MS ACCESS MVP>
 
I did import directly from the file. I am now sure that either this file has an
error somewhere in it or it is just too big to import into a database
application. I downloaded a trial of Filemaker pro and it crashed that too.

A friend is going to try to put it on his SQL server and then pull it into
Access for me that way, thanks for the help though
 
If the SQL setup doesn't work, post back. I would still expect ACCESS to be
able to import this file.
 
Back
Top