Importing from Access
Importing from Access
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Importing from Access

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am importing a report from Access. Some of the information is in number format. I am pasting only certain cells from Access to excel. I then put in a formula in a blank cell like: =sum(f2-g2); I get the answer/value from that expression/formula but when I drag down to continue the same formula the formula/s are correct but the value is WRONG. i.e. - =sum(f3-g3),etc. but the value from the first cell f2-g2 say it is 5, 5 will be the value for all the other cells? HELP - Is there a formatting issue w/ numbers?????

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Tennessee
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Just a suggestion, have you tried exporting from access to an excel file (analyze with excel) then formating the workbook to suit you needs?

    FWIW

    Dave

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com