Import Transformation of Data Tables

  • Thread starter Thread starter Anna Heinrich
  • Start date Start date
A

Anna Heinrich

There was a thread back at 10/15/07 that addressed this but the solution
required PERL which i'm not familiar. I have a large table in excel with
many columns. I want to bring it into Access as a table wtih many many rows
and only 3 columns. Basically trying to convert a crosstab into a simple
database. Any ideas? I'm somewhat familiar with VBA but not too much. It
is a scheduling spreadsheet so there are about 42 columns (6 weeks).
 
Back
Top