Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Microsoft Access Problem

Posted on 2013-05-17
Medium Priority
Last Modified: 2013-08-21
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.

Question by:ModernITSupport
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +5
LVL 28

Expert Comment

ID: 39174947
How are you attempting to imoport the file?  What version of Access?
OM Gang

Author Comment

ID: 39174962
On the toolbar across the top it has import text file and it is on version 2013
LVL 28

Expert Comment

ID: 39174968
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 20

Expert Comment

ID: 39174987
Can you open the file in Notepad?   Perhaps that will help determine what's going on.

Scott C
LVL 24

Expert Comment

ID: 39174994
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.

LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39175047

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?
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39175249
Asked by: ModernITSupport ,

How about posting this CSV file for us to examine...?
LVL 48

Expert Comment

by:Dale Fye
ID: 39175302
Have you tried using the Import Specification?  The two attachments show the general import wizard,import wizard main form and then if you click the Advanced button on the Import Wizard, you can define your CSV fields more explicitlyimport spec, 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.

Accepted Solution

chrisezard earned 2000 total points
ID: 39179551
Another approach is to link the csv file to an Access table.
   External Data\Text File.
   Select Link to the data source...
   Press Browse to select your csv file and follow the Text Import Wizard.

Then import the data using an Append Query from the linked table to your target table.
This allows you to skip, rename, etc, columns from the csv file to match the target table.

You can see what's in the csv file, and you control the import process, for example you could filter records from the csv file with a WHERE clause in your Update Query. This works very well with large csv files.

Author Comment

ID: 39427338
I've requested that this question be deleted for the following reason:

not needed

Expert Comment

ID: 39428022
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.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question