+ Reply to Thread
Results 1 to 2 of 2

spreadsheet

  1. #1
    teddkilroy
    Guest

    spreadsheet

    Looking for opinions for a solution. I scan about 50 invoices a month with
    OCR software that saves them as PDF. Looking to create template spreadsheet
    and import data into the following way:
    company name, physical address, check # and amount

    Can PDF be imorted into excel or should I be looking into creating a access
    dbase?

  2. #2
    CLR
    Guest

    Re: spreadsheet

    I have not done much with this, but on one project I found that if I used
    the Full Acrobat Program, I could programmatically import data from a pdf
    file, However, my user only had the Acrobat Reader Program, so the "import"
    step had to be done by hand (SelectAll, CtrlC, CtrV) to get the data into
    Excel. Then macros could take it from there and split it into columns and
    manipulate it per my needs.....

    hth

    Vaya con Dios,
    Chuck, CABGx3


    "teddkilroy" <teddkilroy@discussions.microsoft.com> wrote in message
    news:CB7AD49A-7D89-45F9-AAEB-E7BC7E9E2958@microsoft.com...
    > Looking for opinions for a solution. I scan about 50 invoices a month with
    > OCR software that saves them as PDF. Looking to create template

    spreadsheet
    > and import data into the following way:
    > company name, physical address, check # and amount
    >
    > Can PDF be imorted into excel or should I be looking into creating a

    access
    > dbase?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1