Refresh Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I inported data in a Exel worksheet and saved as .CSV file. When I re-open
this file and try to do refresh data, the refresh data button is not on. how
can i refresh data for my file? thanks
 
Once you saved that file as a .csv file, any query you had was lost--were you
writing about Data|Import External Data?

If not, you may want to explain more.
 
Thank Dave,

Yes. I was writing about Data|Import External Data. If I want to do
refreshing data, what kind of file I should saved to?
 
I would think you'd want to keep the excel file as a real excel file (*.xls).
Then you could refresh the query when you know the csv file changes.


Thank Dave,

Yes. I was writing about Data|Import External Data. If I want to do
refreshing data, what kind of file I should saved to?
Click to expand...
 

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

Access Form Refresh 1
Data Query grayed out 2
Lookups - how to obtain data from a master spreadsheet into another 5
Refresh order when refreshing all in a workbook 1
External Data Toolbar permanently greyed out. 7
Database Query Missing 4
External Data Refresh all just for one worksheet 3
How to save the setting on displayi toolbar for refresh external d 4

Back
Top