Hello Mike,
Tuesday, April 23, 2002, 5:00:19 AM, you wrote:
MC> Hi Paul -
MC> I am working with Office 2000 so some of the verbage may be a little
MC> different.
MC> In the Excel file let's say your percent values are in column A with a
MC> title in cell A1 and the values starting in cell A2 and below.
MC> In cell B2 enter the formula "=value(a2)" without the quotes. This
MC> will take the text values that are in column a and convert them to
MC> numeric values in column B. I tried the inport at this point and it
MC> went fine but you said you can not inport formulas so next you will
MC> want to highlight column B (click on the B above the column) right
MC> click on the highlighted column and select copy. Right click again on
MC> teh highlighted column and select paste special. In the box that comes
MC> up select values and then click OK. Now your inport should work OK
MC> (and with the formulas converted to values you can delete column A
MC> before you import).
MC> Once you have the data in Access you will need to open the table,
MC> switch to design view, select the field that has your percents in it
MC> and change the format to percent. This will allow you to see the
MC> number in percent form instead of as a decimal number.
MC> Regards,
MC> Mike
Formula "=value(a2)" works fine, and so does the "paste special" in
the Office 97.
However, in Excel you can convert the "percentage type" of the cell
to the "text type", and then during import process in Access the
field type can be changed.
--
Best regards,
Yakymakha
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|