Macro Error when Transferring Text

Posted on 2013-06-12
Last Modified: 2013-06-20
Following is the Macro command
mport Delimited, CostInfoMtd Import Specification, TCPlusEngrHrsMTD, \\MAINSERVER\Access Application\CostInfoMTD.csv, Yes, ,

This works when I do the manual import, but does not work when I use the macro action...get error "Query must have at least one destination file".

Attached are screen shot of the Import Spec, plus the .csv being imported.

I've seen some issues re "trusted files", but the .csv file is in the same folder as the Access 2007 Application.
Question by:gmapdc
  • 3
  • 3
LVL 33

Expert Comment

ID: 39243011
Are you importing directly to an existing table?

If you are perhaps you should import into a new table and then append the data to the existing table.

Author Comment

ID: 39245359
I tried importing to a new table, but got the same error.

Author Comment

ID: 39260346
Question is still open - need help!
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

LVL 33

Accepted Solution

Norie earned 500 total points
ID: 39260383
You've selected Skip for all the fields in the import specification.

Author Comment

ID: 39263232
My BAD - I was trying to check to include the fields - completely missed the header that said
said "Skip".   Thank you so much for your help.
LVL 33

Expert Comment

ID: 39263320
No problem.

I should have spotted it earlier but I only had a quick look at the image of the import specification and it looked fine.

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now