Importing a large ".chr" text file into Access 2000

[PNB]

Using Windows 2000 and Access 2000, I would like to import
a ".chr" text file (>100k lines) into Access, but this
extension is not recognised by my Access version.

Any idea will be appreciated, as I am getting desparate to
get any sensible answer from my in-house helpdesk.

Kind regards from Birmingham, UK.

 

[Cheryl Fischer]

If the file is truly a text file, just rename it, changing the file type to
TXT.

If you expect to get these files on a regular basis, you might want to try
contacting the person or entity creating them for you to request that the
file type be named with TXT as the file type.

hth,

 

[JSand42737]

Using Windows 2000 and Access 2000, I would like to import
a ".chr" text file (>100k lines) into Access, but this
extension is not recognised by my Access version.

Any idea will be appreciated, as I am getting desparate to
get any sensible answer from my in-house helpdesk.

Kind regards from Birmingham, UK.

A quick tip for this. Rather than changing the file extension, you can import
it as it is, by wrapping the name of the file in the dialog box in double
quotes. And obviously if you are using code to import the data, then the file
extension doesn't matter.

 

[Douglas J. Steele]

Using Windows 2000 and Access 2000, I would like to import
a ".chr" text file (>100k lines) into Access, but this
extension is not recognised by my Access version.

Any idea will be appreciated, as I am getting desparate to
get any sensible answer from my in-house helpdesk.

Kind regards from Birmingham, UK.

A quick tip for this. Rather than changing the file extension, you can import
it as it is, by wrapping the name of the file in the dialog box in double
quotes. And obviously if you are using code to import the data, then the file
extension doesn't matter.[/QUOTE]

I'm not so sure about that, Jon.

Check the following:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

I don't think the behaviour's any different in 2002 or 2003.

 

[JSand42737]

A quick tip for this. Rather than changing the file extension, you can import
it as it is, by wrapping the name of the file in the dialog box in double
quotes. And obviously if you are using code to import the data, then the file
extension doesn't matter.

I'm not so sure about that, Jon.

Check the following:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

I don't think the behaviour's any different in 2002 or 2003.
[/QUOTE]

I forgot about this with A2K/Jet4. I remember coming up against it a few months
ago on one of the computers that I use, and turning the air blue because I
couldn't work out what was going wrong. Its a major PITA for me as I deal a lot
with assorted data files that are text files but do not have a .txt extension,
instead being called "data.02" (mainly because a lot of them are run through
old FORTRAN programs first which are limited to 8.3 file names.

 

[Douglas J. Steele]

I forgot about this with A2K/Jet4. I remember coming up against it a few months
ago on one of the computers that I use, and turning the air blue because I
couldn't work out what was going wrong. Its a major PITA for me as I deal a lot
with assorted data files that are text files but do not have a .txt extension,
instead being called "data.02" (mainly because a lot of them are run through
old FORTRAN programs first which are limited to 8.3 file names.

Easiest solution is to rename the file, do the import, then name it back. If
you haven't got sufficient permissions to do that, perhaps you can copy the
file, import it, then delete the copy.