data conundrum

I had about 100 csv files to import into 1 table in my access data
base. I was able to merge the csv files into one table first and
then
import the large file into MS access. Upon finishing the import, I
noticed one thing about the data; the number of columns in each of my
csv files is inconsistent, so the data does not line up properly.
Column 9 in one table correlates to column 18 in another table. As a
result, the mega table is mostly useless gibberish.

There is no consistency within the 100 initial csv files. The data
is
just feeds from various systems. Is there a way to sort this
efficiently? I need each field to align with the proper values. How
do I tell access to find the correct value for a given field when
that
value could be in one of 40 or so columns?


If anyone has a clue to help solve this data puzzle I would
appreciate
the tips. I am not very strong in VBA so ideally I need a viable
work
around.


Thank you!!


.

Relevant Pages

  • RE: csv into excel education
    ... The data in our csv files need to go to their proper place in the excel spreadsheet ...
    (microsoft.public.excel.misc)
  • Re: data conundrum
    ... Are the field names consistent across all the files, ... If possible, standardise them. ... standardise the field names in the CSV files, ... I need each field to align with the proper values. ...
    (microsoft.public.access.externaldata)
  • data conundrum
    ... I had about 100 csv files to import into 1 table in my access data ... just feeds from various systems. ... Is there a way to sort this ... I need each field to align with the proper values. ...
    (microsoft.public.access.externaldata)
  • Re: MySQL -> PHP -> MS Excel?
    ... In message, Sherm Pendley writes ... in MS-Excel format - they don't want to have to do an import of any ... sort. ... My PC uses the Excel icon for CSV files as well, but your idea is a good one. ...
    (comp.lang.php)