• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

Macro Error when Transferring Text

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.
CostInfoMtd.csv
MacroError.xlsx
0
gmapdc
Asked:
gmapdc
  • 3
  • 3
1 Solution
 
NorieVBA ExpertCommented:
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.
0
 
gmapdcAuthor Commented:
I tried importing to a new table, but got the same error.
0
 
gmapdcAuthor Commented:
Question is still open - need help!
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
NorieVBA ExpertCommented:
You've selected Skip for all the fields in the import specification.
0
 
gmapdcAuthor Commented:
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.
0
 
NorieVBA ExpertCommented:
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.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now