Link to home
Create AccountLog in
Avatar of ModernITSupport
ModernITSupport

asked on

Microsoft Access Problem

I have a Microsoft Access database and I am trying to import a CSV file, which contains additional data into the database, but I receive the error message "Can not perform this action" - is there any way of narrowing this down? As I am unsure where to start.

Thanks,
Reece
Avatar of omgang
omgang
Flag of United States of America image

How are you attempting to imoport the file?  What version of Access?
OM Gang
Avatar of ModernITSupport
ModernITSupport

ASKER

On the toolbar across the top it has import text file and it is on version 2013
I don't have Access 2013 but suggest you try first to save the .csv file as a .txt file and see if Access will import it then.
OM Gang
Can you open the file in Notepad?   Perhaps that will help determine what's going on.

Scott C
Open the file in Excel, ensure that the data is in a tabular format (use Insert>Table if nescessary to be sure). Save as xlsx.
Use Access import from Excel. This can be better as the data will hopefully in a more Access freindly format.

ATB
Steve.
@ModernITSupport

if you are importing the .csv file to an existing table, and you are getting the error
- the structure of the existing table does not match the .csv file, csv file may have more columns.

- import the .csv file to a NON existing table. do you still get the error?
Asked by: ModernITSupport ,

How about posting this CSV file for us to examine...?
Have you tried using the Import Specification?  The two attachments show the general import wizard,User generated image and then if you click the Advanced button on the Import Wizard, you can define your CSV fields more explicitlyUser generated image, including indicating which ones to ignore.  You can also save the specification once you have it right so that you can re-use it if you are going to import data from that CSV format on a regular basis.
ASKER CERTIFIED SOLUTION
Avatar of chrisezard
chrisezard
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I've requested that this question be deleted for the following reason:

not needed
Thanks for the points!
I often search EE and find what I am looking for without asking questions. This question shows two different ways to import csv files, a common issue. For this reason I suggest it should not be deleted but I am happy to accept the Moderator's decision.