Import Flat File from cdrom

[Hillbillie]

I am trying to import a flat file that contains Highschool student ACT
scores. These will come to us on a cd. Here is a link to the format
of the file.

http://www.act.org/aap/infosys/pdf/790Test08_09.txt

Here are instructions.

http://www.act.org/aap/infosys/recordinfo.html

It looks like one student per line with a usual header. I just don't
know how to write the VB in Microsoft Access 2003 from scratch. A
little help from someone will go a long way. I have written a lot in
access vb, but not on flat files.

Thanks,

Larry

 

[Jeff Boyce]

Why do you figure you'll need VBA?

Depending on data format, you can link to the raw data, then use queries to
"parse" the data into your more permanent well-normalized Access table
structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pietlinden]

looks like a standard fixed-width file. You can map it and then use a
query to import it into a single table and then parse it... or just
import it directly. It needs alot of cleanup, though.

 

[John W. Vinson/MVP]

I am trying to import a flat file that contains Highschool student ACT
scores. These will come to us on a cd. Here is a link to the format
of the file.

http://www.act.org/aap/infosys/pdf/790Test08_09.txt

Here are instructions.

http://www.act.org/aap/infosys/recordinfo.html

It looks like one student per line with a usual header. I just don't
know how to write the VB in Microsoft Access 2003 from scratch. A
little help from someone will go a long way. I have written a lot in
access vb, but not on flat files.

No VB is needed. You can use File... Get External Data... Link (or
Import), use the wizard, and rather tediously go through the defined
columns and name the fields. It's not hard, just timeconsuming.