Excel & Access?

Can I link data from an Access Data Base to an Excel Invoice?

4 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Sure! I don't know why the first guy says it doesn't work, I've done it many times. If you're in Excel and you want to bring in Access Data, just go to Data, Import External Data and browse to your file. The dialog will show you available queries and tables within the database. Pick one and BAM! the data pops right in.

  • Anonymous
    1 decade ago

    Well, you will think that you can, and if you obey their advertising hype, you will try to do it, but, it doesn't work.

    You can import all Microsoft Office file formats, dating back to 1986, into OpenOffice, and then manipulate and export to another file format!

    http://openoffice.org and it is included in http://pclinuxos.com with 1900 other FREE programs, suites, applications, solutions, games.

    You are gonna love what Free, Open Source Software does for your high speed computer! (runs upto 50 X faster, in most processes, in benchmark testing programs and shoot-outs).

  • unnga
    Lv 6
    1 decade ago

    It can be done. Check out books by Eric Wells which he explains how to.

  • Anonymous
    1 decade ago

    Actually.... hmmm. Try openoffice.org! It's free and great!

Still have questions? Get your answers by asking now.