Avatar of maximyshka
maximyshka
 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?
Microsoft Access

Avatar of undefined
Last Comment
maximyshka

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
Your help has saved me hundreds of hours of internet surfing.
fblack61