Alpha Video Training
Results 1 to 2 of 2

Thread: Problem with Importing Excel Worksheets

  1. #1
    Member
    Real Name
    Kenyon Sprankle
    Join Date
    Jun 2011
    Location
    Marlton, NJ
    Posts
    177

    Default Problem with Importing Excel Worksheets

    Have client that posts financial data to Excel worksheets over a 5 week period and then manual enters data to Quickbooks enterprise on a desktop.
    Wants to automate process by extracting various cells and post them to QB.

    Tried to import Excel file directly via AlphaDAO and it inserts heading dates into dollar fields in cells below. Exported to CSV format and imported thru operation function with numeric fields for dollars fields. It converts date heading to numeric, i.e. 12/31/2102 to 12. Not a big problem, as I can prompt for dates. Negative values are format as
    (20.00), instead of -20.00, resulting on zero value in import. can have them change to number format for input. Big problem is any value over 3 digits has first 3 digits dropped. i.e 1,974.12 becomes 1.00, 2,270.00 becomes 2.00. If I import with dollar fields as character, everything comes over find, except I don't think QB would like posting a character field to a numeric field. Even tried to use copy record operation with output field being numeric, but it carred over the input format, changing numeric output to character.

    Anybody know why over 3 digit fields are being screwed up or why date headings are replacing dollar fields when trying to connect directly to Execl file?

    I will be using xbasic to pull off the cells/rows(i.e. 27-34, 37-59,etc) I need to post to QB and create another file to use for posting. Hopefully using xbasic to move the character dollar field to a numeric field will solve the problem.

    The next challenge will be to connect directly with QB desktop to do posting. The alterative is to create IIF import transaction that can be imported into QB.

    How do I add attachments of Excel file and dbf imports?

  2. #2
    Member
    Real Name
    Kenyon Sprankle
    Join Date
    Jun 2011
    Location
    Marlton, NJ
    Posts
    177

    Default Re: Problem with Importing Excel Worksheets

    Never Mind. I normally don't change a client's data, but I went ahead and did the obvious thing and removed the headings over the dollar cells and the direct connect via AlphaDAO worked. Dropped some descriptions in titles in left column, buit I can live with that.

Similar Threads

  1. Alpha5 and MS Excel with Multiple Worksheets
    By ppham in forum Alpha Five Version 8
    Replies: 13
    Last Post: 01-15-2008, 11:12 AM
  2. importing problem Excel .xls >> A4 (v8)
    By Ken Fletcher in forum Alpha Four Versions 7 and 8
    Replies: 4
    Last Post: 01-03-2005, 08:34 AM
  3. Importing from Excel
    By TerriH in forum Alpha Five Version 4
    Replies: 1
    Last Post: 06-05-2002, 05:06 PM
  4. Importing from Excel V4
    By Ranny Robertson in forum Alpha Five Versions 2 and 3
    Replies: 2
    Last Post: 04-12-2002, 04:57 AM
  5. Importing Excel
    By Lane Beckes in forum Alpha Five Version 4
    Replies: 5
    Last Post: 08-21-2001, 05:13 PM

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
  •