Urban planning community

+ Reply to thread
Results 1 to 2 of 2

Thread: Excel into Access question

  1. #1
    Cyburbian michaelskis's avatar
    Registered
    Apr 2003
    Location
    Someplace between yesterday and tomorrow.
    Posts
    12,296

    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?
    Not my monkey, not my circus. - Old Polish Proverb

  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.
    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