Importing from Access

jordandi · Mar 19th, 2002, 05:38 PM

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?????

Dave · Mar 19th, 2002, 07:04 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 05:38 PM	#1
jordandi New Member Join Date: Mar 2002 Posts: 1	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?????

Mar 19th, 2002, 07:04 PM	#2
Dave New Member Join Date: Mar 2002 Location: Tennessee Posts: 25	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