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!!!
Number of columns you can import into
- Thread starter dcarr
- Start date
- Local time
- Today, 15:25
- Joined
- Feb 28, 2001
- Messages
- 30,350
This might be a limit on the Wizard. Queries can have many more than 36 columns.
Look up help topic "Query Specifications" under AC2K or "Query Limits" under AC97.
Look up help topic "Query Specifications" under AC2K or "Query Limits" under AC97.
pcs
Registered User.
- Local time
- Today, 15:25
- Joined
- May 19, 2001
- Messages
- 398
not sure what is amiss, but i recently did a project (in A97) that imported 52 fields and did it using the import wizard w/no problems.
guess it's possible later versions of the import wizard have been 'improved'.
does access give any errors when you do the import?
al
guess it's possible later versions of the import wizard have been 'improved'.
does access give any errors when you do the import?
al
- Local time
- Today, 16:25
- Joined
- Feb 19, 2002
- Messages
- 47,353
Mabe there's something wrong with the file. Can you import it into excel? Are you trying to append the data to an existing table or are you trying to make a new table?
Importing into a table
Apologies for the late reply.
I have tried to import the file into Excel and it worked fine. I can only assume there is a limit on the number of columns in a table you can import into?
Does anyone know of any newer releases of the import wizard that have been released by Microsoft? If so could you pass on the URL of the site I need to go to in order to download and update my software?
Thanks guys
Apologies for the late reply.
I have tried to import the file into Excel and it worked fine. I can only assume there is a limit on the number of columns in a table you can import into?
Does anyone know of any newer releases of the import wizard that have been released by Microsoft? If so could you pass on the URL of the site I need to go to in order to download and update my software?
Thanks guys
Importing into an MS Access table
Thanks for the reply.
I have created an import specifcation using an ODBC data source but this does not seem to solve the porblem. It only picks up that there are 36 data sources (columns) within the text file. The file is delimited and is split by commas.
Any ideas why it would not work?
Thanks for the reply.
I have created an import specifcation using an ODBC data source but this does not seem to solve the porblem. It only picks up that there are 36 data sources (columns) within the text file. The file is delimited and is split by commas.
Any ideas why it would not work?
Importing data
The way in which the table is structured will not allow for an *.xls import? The table has been in use for some time now and I do not really want modify its structure as this is an important reporting system that is used each and every day.
It only allows for a CSV import. The idea of importing into Excel had crossed my mind.
Are there any updates for the import text wizard that Microsoft may have released recently?
The way in which the table is structured will not allow for an *.xls import? The table has been in use for some time now and I do not really want modify its structure as this is an important reporting system that is used each and every day.
It only allows for a CSV import. The idea of importing into Excel had crossed my mind.
Are there any updates for the import text wizard that Microsoft may have released recently?
Importing data into a table
Regarding the *.xls import. I attempted to import the file into acopy of the table after copying its structure and due to its file size, it takes and absolute age to import the data!!
Any other suggestions? Thanks
Regarding the *.xls import. I attempted to import the file into acopy of the table after copying its structure and due to its file size, it takes and absolute age to import the data!!
Any other suggestions? Thanks
- Local time
- Today, 15:25
- Joined
- Feb 28, 2001
- Messages
- 30,350
The only other thing that could be in the way is the size of the table and the nature of what you are importing.
Last I looked, Excel limits its cells to 255 bytes but doesn't enforce a record length because Excel isn't record-oriented. It is entirely cell-oriented. (Proof: rows and/or columns can be sparsely populated and cells within either can have independent formats.) A .CSV file doesn't have a relatively low record sizing limit if I recall correctly. Lines can get pretty big. Basically it is a data stream file usable by C++ with variable length records.
If you have a lot of long text fields, you might be running into a record sizing problem. If your text fields lead to a record length that would exceed 2K bytes, I think you are hosed on a direct import. For 36 columns, that would be an average of 55 or 56 bytes per field.
Are you importing a bunch of long text fields?
In that case, you might NEVER import that data because Access limits record lengths pretty severely. Give us a few more details about record sizes, field counts, etc, and we might be able to figure a workaround. But from where we sit, we are obviously having trouble figuring out what is going on.
Last I looked, Excel limits its cells to 255 bytes but doesn't enforce a record length because Excel isn't record-oriented. It is entirely cell-oriented. (Proof: rows and/or columns can be sparsely populated and cells within either can have independent formats.) A .CSV file doesn't have a relatively low record sizing limit if I recall correctly. Lines can get pretty big. Basically it is a data stream file usable by C++ with variable length records.
If you have a lot of long text fields, you might be running into a record sizing problem. If your text fields lead to a record length that would exceed 2K bytes, I think you are hosed on a direct import. For 36 columns, that would be an average of 55 or 56 bytes per field.
Are you importing a bunch of long text fields?
In that case, you might NEVER import that data because Access limits record lengths pretty severely. Give us a few more details about record sizes, field counts, etc, and we might be able to figure a workaround. But from where we sit, we are obviously having trouble figuring out what is going on.
Importing data into a table
Apologies for the duplicate entries I wasnt sure which discussion group to drop the request in.
The file I am attempting to import is extremly large, and the records within the table are of a byte size similar to that you disucussed in an earlier thread.
I have attached a copy of the file (an example) to this thread.
Many thanks for your help
Apologies for the duplicate entries I wasnt sure which discussion group to drop the request in.
The file I am attempting to import is extremly large, and the records within the table are of a byte size similar to that you disucussed in an earlier thread.
I have attached a copy of the file (an example) to this thread.
Many thanks for your help
