|
 |
access thread: Importing Text (.csv) files into Access 97
Message #1 by "Beverly Usher" <bUsher@h...> on Tue, 27 Mar 2001 08:45:38 +0100
|
|
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
Message #2 by "Craig Flannigan" <ckf@k...> on Tue, 27 Mar 2001 10:01:39 +0100
|
|
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #3 by "Beverly Usher" <bUsher@h...> on Tue, 27 Mar 2001 11:10:42 +0100
|
|
No, the data is distributed in tables in many .mdb files, with a
"central" file linking to the data and carrying queries, forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #4 by "Craig Flannigan" <ckf@k...> on Tue, 27 Mar 2001 11:30:29 +0100
|
|
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #5 by "Beverly Usher" <bUsher@h...> on Tue, 27 Mar 2001 12:04:26 +0100
|
|
It also won't import 1000 records. It just won't read any of these
files, even quite small ones. I may have to set up a separate computer
for this and use Access 2000 as it picks the files up fine.
Thanks for the comments!
>>> ckf@k... 27/03/2001 11:30:29 AM >>>
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #6 by "Craig Flannigan" <ckf@k...> on Tue, 27 Mar 2001 12:22:16 +0100
|
|
What does it say when you try to import the file?
Any error messages? What's the outcome?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 12:04 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It also won't import 1000 records. It just won't read any of
these
files, even quite small ones. I may have to set up a
separate computer
for this and use Access 2000 as it picks the files up fine.
Thanks for the comments!
>>> ckf@k... 27/03/2001 11:30:29 AM >>>
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #7 by "Beverly Usher" <bUsher@h...> on Tue, 27 Mar 2001 13:10:47 +0100
|
|
It starts the import, says "Loading wizzards" at the bottom of the
screen on the left, then hangs. For example, on one of the .csv files
that was 69K, after 40 minutes it put up a message box that said
"Overflow!". On the others, it just seemed to hang forever. I left it
overnight on a big file to see if anything would come up. It starts the
import, says "Loading wizzards" at the bottom of the screen on the left,
then hangs. Note: if I am importing an Excel file, the wizzard comes up
pretty quickly.
Hope this helps.
Beverly
>>> ckf@k... 27/03/2001 12:22:16 PM >>>
What does it say when you try to import the file?
Any error messages? What's the outcome?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 12:04 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It also won't import 1000 records. It just won't read any of
these
files, even quite small ones. I may have to set up a
separate computer
for this and use Access 2000 as it picks the files up fine.
Thanks for the comments!
>>> ckf@k... 27/03/2001 11:30:29 AM >>>
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #8 by "Craig Flannigan" <ckf@k...> on Tue, 27 Mar 2001 13:23:38 +0100
|
|
You version of Access, or the add-on parts are corrupt. I've
had this before.
You need to re-install Access 97. It was the only way around
it for us. After that, it worked fine.
Craig.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 01:11 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It starts the import, says "Loading wizzards" at the bottom
of the
screen on the left, then hangs. For example, on one of the
.csv files
that was 69K, after 40 minutes it put up a message box that
said
"Overflow!". On the others, it just seemed to hang forever.
I left it
overnight on a big file to see if anything would come up. It
starts the
import, says "Loading wizzards" at the bottom of the screen
on the left,
then hangs. Note: if I am importing an Excel file, the
wizzard comes up
pretty quickly.
Hope this helps.
Beverly
>>> ckf@k... 27/03/2001 12:22:16 PM >>>
What does it say when you try to import the file?
Any error messages? What's the outcome?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 12:04 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It also won't import 1000 records. It just won't read any of
these
files, even quite small ones. I may have to set up a
separate computer
for this and use Access 2000 as it picks the files up fine.
Thanks for the comments!
>>> ckf@k... 27/03/2001 11:30:29 AM >>>
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #9 by "Beverly Usher" <bUsher@h...> on Tue, 27 Mar 2001 14:15:21 +0100
|
|
It's happening on several computers here. They probably were ghosted off
a bad copy. Thanks! Beverly
>>> ckf@k... 27/03/2001 1:23:38 PM >>>
You version of Access, or the add-on parts are corrupt. I've
had this before.
You need to re-install Access 97. It was the only way around
it for us. After that, it worked fine.
Craig.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 01:11 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It starts the import, says "Loading wizzards" at the bottom
of the
screen on the left, then hangs. For example, on one of the
.csv files
that was 69K, after 40 minutes it put up a message box that
said
"Overflow!". On the others, it just seemed to hang forever.
I left it
overnight on a big file to see if anything would come up. It
starts the
import, says "Loading wizzards" at the bottom of the screen
on the left,
then hangs. Note: if I am importing an Excel file, the
wizzard comes up
pretty quickly.
Hope this helps.
Beverly
>>> ckf@k... 27/03/2001 12:22:16 PM >>>
What does it say when you try to import the file?
Any error messages? What's the outcome?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 12:04 PM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
It also won't import 1000 records. It just won't read any of
these
files, even quite small ones. I may have to set up a
separate computer
for this and use Access 2000 as it picks the files up fine.
Thanks for the comments!
>>> ckf@k... 27/03/2001 11:30:29 AM >>>
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.
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 11:11 AM
To: Access
Subject: [access] RE: Importing Text (.csv) files into
Access 97
No, the data is distributed in tables in many .mdb files,
with a
"central" file linking to the data and carrying queries,
forms and
reports.
The file I want to import into is an empty .mdb file.
>>> ckf@k... 27/03/2001 10:01:39 AM >>>
"I maintain about 2 GB of Access 97 data & reporting on my
computer"
Is this 2GB all in one Access 97 File? Is this the file you
are trying to import the CSV file into?
-----Original Message-----
From: Beverly Usher [mailto:bUsher@h...]
Sent: 27 March 2001 08:46 AM
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
Message #10 by "Derrick Flores" <Derrick_Flores@s...> on Tue, 27 Mar 2001 08:29:09 -0600
|
|
Subject: Re: [access] Importing Text (.csv) files into Access 97
Hello Beverly, what you might want to do is import the files into an
Access 2000 database and then converted the database
to the "Previous Version" which is Access 97. Don't forget after you
import your files into 2000, compact and repair the database.
Hint: You might have to create a blank database with a dummy table first
before converting it to 2000 so you can have the option to
convert back to 97. Hope that will solve your problem, let me know.
>>> "Beverly Usher" <bUsher@h...> 03/27 1:45 AM >>>
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
Message #11 by "Chris Kryshtalowych" <ckryshtalowych@u...> on Tue, 27 Mar 2001 16:41:06 -0500
|
|
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>
Message #12 by "Zonker, Janan" <jzonker@E...> on Tue, 27 Mar 2001 17:07:19 -0800
|
|
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
Message #13 by "Craig Flannigan" <ckf@k...> on Wed, 28 Mar 2001 12:37:06 +0100
|
|
Have you applied Office Service Packs?
We've over 200 PC's with Access on, and not one of them does
it! I wish we had your setup.
-----Original Message-----
From: Chris Kryshtalowych [mailto:ckryshtalowych@u...]
Sent: 27 March 2001 10:41 PM
To: Access
Subject: [access] Re: Importing Text (.csv) files into
Access 97
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>
|
|
|
View Cart
