Refresh Data

J

JJ

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
 
D

Dave Peterson

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.
 
J

JJ

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?
 
D

Dave Peterson

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 Query to import from Sharepoint 0
XML Map Refresh on Open 0
External Data Toolbar permanently greyed out. 7
Data Query grayed out 2
Can I refresh worksheets in a specific order when I open a file? 0
Refresh order when refreshing all in a workbook 1
Refresh some not Refresh All 1
Create a dynamic master file 1

Top