importing file

[metalman]

have setup a microsoft access 2000 database. when i go to import the file the import options wont let me select the needed extension (.JRN) how could i import this file into the database with or with out the import in the file menu. also the drop down menu only lets me select text,excell, odbc,lotus1-2-3 files.

 

[CID8]

whats a JRN file?

CID8

 

[jcpelejo]

Have you tried converting the .JRN file into a text format and then import the information?

 

[metalman]

the .jrn file are files converted from pascal to ascii and from the conversion program it wont let me change them to or reformat to text

 

[jcpelejo]

Hi metalman,
Try using this shareware application to convert your file.

http://download.cnet.com/downloads/0-10234-100-6859773.html.

I have not tested it myself but I hope it does the trick.

 

[metalman]

jcpelejo will download and try it thanks for your help

 

[jebry]

Hi!

If that download doesn't look, maybe you can open it in Excel and save the data as a spreadsheet which you can then transfer into Access.

hth Jeff Bridgham
bridgham@purdue.edu