Unfortunately, the file does have fixed length fields. I think it must

be a problem with bad files somewhere in Access, but I don't know

whether anyone here can find any disks (everything is ghosted or sent

out with snapshots). Meanwhile, I have found that I can read it all in

with Access 2000 then write it out as an old version of Access, zip that

onto floppies (several) and read it fine on my computer.



Thanks all for the help!

Beverly



>>> ckryshtalowych@u... 27/03/2001 10:41:06 PM >>>





Craig...I very regularly import  csv text files of sizes much greater

than 80mb

into access 97.  Quite often these text files contain in excess of a

million

records each.  And I import them all in one "pop," without breaking

things up

into groups of 10,000 or so records.  Sure, it's time consuming, but it

does

work without a hitch.  Remember, a single access97 mdb file is limited

not by

the number of records; instead there is a cap of 1GB in file size.  As

long as

you are willing to sit around and twiddle your thumbs while access

chugs away,

you can do it.



That being said, my digression still hasn't answered Beverly's question

of why

she cannot import the text files into access97 but CAN import them into

A2K.

The only solution that comes to my mind is very clunky:



Import the csv file into an Access2000 table.  Then, EXPORT the file

back out to

another, new, text file (try a fixed-width text file this time). 

Finally, try

importing the new, fixed width file into Access97.



If that works, you can buy me a beer.  If it doesn't work, you can vote

me off

the island.



chris kryshtalowych

systems specialist/boy genius

ckryshtalowych@u... 



<snip>

>Subject: RE: Importing Text (.csv) files into Access 97

>From: "Craig Flannigan" <ckf@k...>

>Date: Tue, 27 Mar 2001 11:30:29 +0100

>X-Message-Number: 24

>

>Access 97 will not import a file of 80MB. It's way too

>large.

>

>Have you tried importing about say, 10,000 records? Do they

>import correctly?

>

>Reading around, and from expeience, you'd struggle to get

>Access 97 to read that amount of data. When we imported

>200,000 records, we needed to do it in 65,000 record blocks

>as Access will not import more than 65,000 or so records in

>one go. That doesn't mean that's all it holds, but it's

>importer is limited. We imported 65,000 and then did it

>again, and merged the two, until we had 200,000 records.

</snip>

The files are way too big for that (I need 168,000 records in one).

B



>>> jzonker@E... 28/03/2001 2:07:19 AM >>>

I've read all the strings...and maybe I'm just not getting it.



Couldn't the .cvs files be reformatted as Excel spreadsheets then

imported?

If I'm speaking out of ignorance, please forgive.



-----Original Message-----

From: Beverly Usher [mailto:bUsher@h...] 

Sent: Monday, March 26, 2001 11:46 PM

To: Access

Subject: [access] Importing Text (.csv) files into Access 97





I will need to move very large amount of data from an old information

system to a new one. The supplier suggests using Access to adjust

problem data and do some re-coding we need to do. We currently use

Access 97 to run reporting on the old system, and I maintain about 2

GB

of Access 97 data & reporting on my computer, which we will need to

keep

up for some time.



Here is my problem: Access 97 will not read the .csv files (comma

delimited text files) exported for conversion, though they are clean,

standard comma delimited text files. Access 2000 reads them perfectly,

but I don't want to try to make the two co-exist when I have 200 users

depending on my for the Access 97 reporting system. I can read the

smaller files into Excel 97 and then into Access 97 (which works

fine),

but one file is 80 MB, so Excel cuts off most of the bottom of it.



Does anyone know what the problem might be with Access 97 text

importing???



Thanks in advance for any help!

Beverly





jzonker@e...