Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Automatic Importing

    Hello everyone I have a question, I have a database that gets data imported into it through Excel spreadsheet. The data that goes into excel is from our Development department. They create the view and publish it as an excel spreadsheet, the user then imports the data from Excel to Access. I think the spreadsheet gets updated every day I was wondering if there was a way to get Access to automatically import new data based off the Date from the excel spreadsheet and import it into access automatically so the user does not have to import manually. Can I make a macro do this?

    thank you

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Macros have many limitations and I would not try to use them for any complex process. A set of VBA procedures could perform the job you describe without any problem.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Macro no
    but what you could do us do an overnight batch import which sucks ghe data out of excel spreadsheets from a specified location into your access db, then deletes the excel file so it doesnt get re imported next time
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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