Importing 2 text files into Access

Resolved · Urgent Priority · Version 2007

Thu 7 Jul 2011, 10:48 Delegate 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:26 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

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