Import Transformation of Data Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
 
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
 
Back
Top