Ms-Query stopping

  • Thread starter Thread starter Steve M
  • Start date Start date
S

Steve M

I'm running an MS-Query to populate my spreadsheet from 2 DBF files -
have a macro that formats the data afterwards

I want the date to go from dd-mm-yyyy to yyyy-mm-dd but Ms-Query won'
allow this to happen

So presently I am needing to save the file as a CSV and shutting dow
excel and reopening to stop the query then running the macro - is ther
any VBA Icould use to resolve this problem?

Any help appreciated
Stev
 
first, make sure you have the Backgroundrefresh property set to false. If
that doesn't help, then You could delete the query. This should leave the
data on the worksheet and you could then reformat it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formatting 1
International Date formatting 4
Csv date format problem 2
date format 6
Date format error with CSV file 6
SQL Syntax Error in Query 2
Dates converted into text 5
parameter format 4

Back
Top