98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing 2 text files into Access
Importing 2 text files into Access
Resolved · Urgent Priority · Version 2007
Thu 7 Jul 2011, 10:48Delegate Mairead said...
Mairead has attended:
Access Intermediate course
Importing 2 text files into Access
From a given scenario, I have been given 2 text files to import. However, I need to have 4 tables created. I have tried to use an append query to create the other 2 tables however it is not letting me do this. I have tried to use a Make Table query which works but wont let me set primary keys saying to change duplicates. Append query isnt working either!I really really need help on this!
Fri 8 Jul 2011, 11:26Trainer Stephen said...
RE: Importing 2 text files into Access
Hi Mairead
Thanks for your question
The make table query is probably the way to go.
Initially I would choose the wizard option not to set a primary key. The problem is that the field you are choosing contains duplicate values and thus the process falls over.
Once the data is in the table you can change the design in design view. If no field contains unique values, then you could always add an autonumber field and make this the primary key.
If this doesn't work, please let me know and I will get back to you
Regards
Stephen
Thu 14 Jul 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create An Inaccessible Field On A FormThere is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this: |
