Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-import csv into Excel?
We have a corporate database with inflexible reporting facilities and want to
export the data as a csv on a regular basis (certainly weekly, possibly even overnight) and then have an Excel file that will automatically refresh itself by picking up the csv data and importing it, from where we can produce all our custom reports, all nicely formatted just how we want them. We have done all this on a manual basis and it achieves exactly what we want. Also we know how to set up the automatic export of a csv from the corp system. Question is, how to automate the import process i.e. instruct Excel to go look for the updated data at a certain time and import it and create a new file. Suggestions, please? Thanks CW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to import data from daily reports (excel) into excel database | Excel Discussion (Misc queries) | |||
Excel auto formats cells with numbers - Can it be disabled? | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How to import Outlook Contact data into Excel | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) |