I tried to read in a text file with fixed width using import wizard on both versions of MSAccess (2003/2007).
I created a table for the data and then started the tedious job of adding all fields to the map.
When I click the advanced button for the first time there are a number of rows and some automated assignment (the table has 215 columns). The initial assignment does not capture all table columns.
When I try to add more fields, the import wizard complains that index out of range, which leads me to believe that somehow there is a maximum number of columns that is smaller than 215.
Is that true? Can one circumvent this limitation?
Right now I created a stored procedure to read line by line and load it into the table but that is very slow.
Thanks,
Marco
I created a table for the data and then started the tedious job of adding all fields to the map.
When I click the advanced button for the first time there are a number of rows and some automated assignment (the table has 215 columns). The initial assignment does not capture all table columns.
When I try to add more fields, the import wizard complains that index out of range, which leads me to believe that somehow there is a maximum number of columns that is smaller than 215.
Is that true? Can one circumvent this limitation?
Right now I created a stored procedure to read line by line and load it into the table but that is very slow.
Thanks,
Marco