Does anyone know the maximum number of columns a CSV file can be imported into an Access table? I cannot seem to import data into more than 36 columns, and I need to be able to import into 37 columns.........So frustrating!!!

Is the 37th column a total? Access does not import fields that it recognizes as totals.

Otherwise, try to create a second copy of the file with just the key field and the 37th column, import this second copy to Approach, and update the other table with this field joining on the key field.

The data being imported is not in fact a total, all of the data is text (characters) and is a summary of data from an import from a system we use. It seems strange it imports all data barring the last two fields.

When you post the same question in multiple topics, you do two things.

1. Dilute the impact of your post.

2. Upset some of the purists in this forum. (I'm not one, but even I hate to re-invent wheels.

Check your thread under the General heading. It has more in it.