Results 1 to 4 of 4
  1. 12-20-2009, 02:34 PM #1
    putnum
    putnum is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    2

    MS Access 2003+Ms Excel 2007 Issue

    How can I get data from a access 2003 db into excel? And also how can I store data from excel 2007 into the access db?



    Many Thanks!
    Adam
    Reply With Quote Reply With Quote
  2. 12-20-2009, 05:46 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Saving your spreadsheet as an XLS should do it. I think the default for Excel 2007 is XLSX which ac2003 can not read.
    Reply With Quote Reply With Quote
  3. 12-20-2009, 05:53 PM #3
    putnum
    putnum is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2009
    Posts
    2
    Ok but how can I write to the database from within excel 2007?
    Reply With Quote Reply With Quote
  4. 12-20-2009, 09:24 PM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Access 2007 can link to an XLS file. What problem are you having?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. 2007 MDE will not Open in Access 2003
    By wmecook in forum Programming
    Replies: 4
    Last Post: 12-01-2009, 05:15 PM
  2. Access 2007 OutputTo Excel 2007 Format (xlsx)
    By FPeteE in forum Access
    Replies: 0
    Last Post: 11-17-2009, 02:35 PM
  3. MS Access 2007 - network interruption issue
    By shsh_shah in forum Access
    Replies: 5
    Last Post: 10-11-2009, 09:47 AM
  4. Ms-Access 2003 migration issue with SQL Server2005
    By dhruvendra in forum Access
    Replies: 0
    Last Post: 04-16-2009, 01:44 AM
  5. access 2003 automation issue
    By BevA in forum Programming
    Replies: 2
    Last Post: 05-01-2006, 08:37 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums