Results 1 to 6 of 6

Importing / updating most recent datafile

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2006
    Posts
    5

    Importing / updating most recent datafile

    I will be recieving daily .csv files that I want to import into my model as efficiently and accurately as possible.

    The two files are EXTRACT1_date and EXTRACT2_date, such that I will have a library that looks like this:

    EXTRACT1_052108
    EXTRACT2_052108
    EXTRACT1_052208
    EXTRACT2_052208
    EXTRACT1_052308
    EXTRACT2_052308 etc.

    Is there a way I can set the data import wizard to pick the most recent files and import them on launch?

    I am not sure if it matters, but I will be opening EXTRACT1 on the first tab of my workbooks and EXTRACT2 on the second. Another workbook will be linked to this worksheets and will contain the model logic.

    Thank you for looking!
    Last edited by Commander; 05-22-2007 at 06:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1