Urban planning community | #theplannerlife

+ Reply to thread
Results 1 to 2 of 2

Thread: Excel into Access question

  1. #1
    Cyburbian michaelskis's avatar
    Registered
    Apr 2003
    Location
    Somewhere between the mountains and the ocean.
    Posts
    17,890

    Excel into Access question

    How can I export an Excel spreadsheet and have it add into an existing Access Database? We get police updates each day, and they come as an Excel spreadsheet, but we would like to keep a full running list in Access.

    Anyone have any ideas?
    If you want different results in your life, you need to do different things than you have done in the past. Change is that simple.

  2. #2
    Cyburbian Breed's avatar
    Registered
    Nov 2004
    Location
    Not Cliff Island, Maine :(
    Posts
    589
    Go to File->Get External Data and simply pull it in.

    You may have to mess with some formatting (possibly saving it as a dbf file) but it's not too difficult.

+ Reply to thread

More at Cyburbia

  1. Excel 2007 and ESRI
    Information Technology
    Replies: 10
    Last post: 04 Dec 2009, 12:49 PM
  2. Abusing MS Excel
    Friday Afternoon Club
    Replies: 11
    Last post: 10 Mar 2006, 10:41 AM
  3. Replies: 7
    Last post: 20 Dec 2005, 12:05 PM
  4. Microsoft Excel question
    Friday Afternoon Club
    Replies: 8
    Last post: 26 Feb 2004, 10:28 AM
  5. Microsoft Access question
    Information Technology
    Replies: 6
    Last post: 19 Nov 2003, 1:51 PM