Urban planning community | #theplannerlife

+ Reply to thread
Results 1 to 2 of 2

Thread: Excel into Access question

  1. #1
    Cyburbian michaelskis's avatar
    Apr 2003
    Here, but where are you?

    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?
    "The alternate domination of one faction over another, sharpened by the spirit of revenge, natural to party dissension, which in different ages and countries has perpetrated the most horrid enormities, is itself a frightful despotism." - George Washington

  2. #2
    Cyburbian Breed's avatar
    Nov 2004
    Not Cliff Island, Maine :(
    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.
    Every time I look at a Yankees hat I see a swastika tilted just a little off kilter.
    Bill "Spaceman" Lee

+ Reply to thread

More at Cyburbia

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