Results 1 to 3 of 3
  1. #1
    gangel is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    194

    import from PDF, but bunches rows together

    Hi everyone,

    So i have a 50 page pdf price list and i need to import it to my DB.

    The table in the pdf is weirdly structured, so it has 4 records then a 'line' then anther 4 record etc etc

    What happens when importing it (the whole thing) is that all 4 records in that section end up being put in the same record.

    eg:
    Item - Cost
    A $5.50
    B $7.00
    C$9.00
    D $8.00

    Import:
    A B C D | $5.50 $7.00 $9.00 $8.00



    thtne

    E F G H

    etc etc

    however IF i just go into teh pdf and copy 4 rows in one section it does it fine and copies ok manually!!

    Ive tried CSV, txt, online conversion...

    Any ideas would be great.
    Getting an excel version off the company is going to be near impossible.

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    difficult to visualise what your data looks like, but suggest import data to a temporary table, then have a query or queries to append the required data to the final destination table

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    pdf is more like an image than structured - like CSV or excel.... I've never had a good experience attempting an import of pdf. Ajax suggests manipulating the structure after import - which may be viable. Otherwise you might look into Adobe software that can export that file out to CSV/excel first - as in interim step....or in fact depending on the source of this document - the data probably originated in structured format before it was made into a pdf and so if that party will send you the original format that would solve the dilemma.....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to remove blank rows when I import from excel
    By timpepu in forum Import/Export Data
    Replies: 3
    Last Post: 09-14-2015, 04:04 PM
  2. Replies: 3
    Last Post: 08-05-2015, 01:30 PM
  3. Can't import all rows
    By Thelaxman in forum Import/Export Data
    Replies: 3
    Last Post: 07-28-2015, 06:33 AM
  4. Replies: 1
    Last Post: 06-27-2014, 09:33 AM
  5. Import Record with Multiple Rows
    By nerkalyn in forum Import/Export Data
    Replies: 6
    Last Post: 02-19-2014, 03:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums