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!!!
Importing data
- Thread starter dcarr
- Start date
mdemarte
Computer Wizard
- Local time
- Today, 13:01
- Joined
- May 8, 2001
- Messages
- 138
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.
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.
CSV file import
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.
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.
- Local time
- Today, 07:01
- Joined
- Feb 28, 2001
- Messages
- 30,556
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.
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.
Similar threads
Solved
Import Filepath Batch