importing text files

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing 2 text files into Access

Importing 2 text files into Access

resolvedResolved · Urgent Priority · Version 2007

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!

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



Thu 14 Jul 2011: Automatically marked as resolved.


Access tip:

Create An Inaccessible Field On A Form

There 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:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

Server loaded in 0.06 secs.