Import Transformation of Data Tables

P

Phoenix

I am stuck. I have a large table of data in many columns and many rows. I
want to bring it into Access as a table of many many rows and a few columns.
Basically, converting a large crosstab back into a simple database. How can
I do this in Access? Thanks
 
J

Jeff Boyce

Step 1 - import the 'raw' data into a 'temporary' table
Step 2 - create queries that parse the pieces into their "final"
(well-normalized) Access tables
Step 3 - run the queries

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

John Nurick

Hi Phoenix,

There's no automatic feature in Access for doing this, but it's
possible one way or another.

1) When you say table, what sort of file is it (e.g. CSV, XLS, MDB)?

2) How many columns are "many"? In particular, more or less than 256?
 
P

Phoenix

John

The file comes in ebcdic format. I use VEDIT software to create an ASCII
file with 700 columns. The number of rows are based on US Census Block
Groups (208,000). My target table is GEOUNITID, FIELD# (2 to 700), COUNT.

Does this help?

Thanks

Phoenix
 
Top