Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing 2 text files into Access
|
|
|
The UK's most regular 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. |
Importing 2 text files into Access
Resolved · Urgent Priority · Version 2007
Reply 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!
For upcoming training course dates see: Pricing & availability
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.
|