asked on

issue with import specifications (limit with amount of fields)

Is there a limit on the amount of field names that I can enter into saved specifications during importing text file into access 2000 database? I am using a current specifications and trying to add to it 3 more fields, but when I go to save it, it does not keep these new fields.

Did anyone experienced with the similar issue?

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

maximyshka

ASKER

My current specs reflect 28 columns. I tried to remove several existing column and I was not able to add new columns.
Also, when I tried to create new specifications I was able to do only half of columns (14).
I aslo was thinking that number of columns in specs is based on imported file. However, I cannot increase imported file.

Any suggestions how can I increase number of columns in specifications

Jeffrey Coachman

Also remember that if you are doing a very basic import...
(Not defining anything special in the import spec)
...you can import a file without an import spec

For example the attached csv file imports fine into an Access 2000 db without any import spec whatsoever, using this code:

DoCmd.TransferText acImportDelim, , "NewTableName", "c:\YourFolder\BasicCSV.csv", True

...Again, I am not sure about any field limits, just something to try.

;-)

Jeff
BasicCSV.csv

maximyshka

ASKER

Jeff, your suggestion is OK only if I import simple excel or csv file

However, I use fixed width import specifications which reflect start point and number of characters. Therefore it's not working.

For some reasons it started working. I created new specification and was able to put 32 fields. Once I saved specs with 32 field, I changed field name and data type. Very strange issue.

Although, I fixed this issue on my own, I would like to thank you for participation