Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2013
    Posts
    14

    Question Unanswered: Pulling From Excel To Access

    My boss asked me to look into pulling information from several excel spreadsheets into one access database.
    For example you wants me to import the date located in cell c3 from every spreadsheet and put them in the first column and then do the same with other cells. so the end have a database where the first row is the information from one day and the next row is the following. etc

  2. #2
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    There are numerous ways to accomplish this. One way is to use linked tables. Another way is to use Excel Automation. Use the search function of the forum and you should come up with numerous examples.

    Once you have decided on an approach let us know if you get stuck or need more help. Without some specifics it's a little hard to give you useful feedback.

    C

  3. #3
    Join Date
    Feb 2013
    Posts
    14
    I tried want to use automation but everything is a bit different because i am using access 2010 instead of the version that all the help files are using

Posting Permissions

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