Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Excel help needed
From:	Paul Roeth <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Mon, 22 Apr 2002 10:13:18 EDT
Content-Type:	text/plain
Parts/Attachments:	text/plain (32 lines)

Hi everyone,

I'm using W'98 with Office'97.  One of the clients I work for sends me files
in Excel format.  In some of the data there are % values.  Ultimately I want
to import these data into Access and do calculations on them.  On importing
these values to Access a text fied results, and I'm offered no way to change
the field type.  Further, if I attempt to change the field type in Access
these values become 1's (I knew this would happen).

Consider these data

        A           B
1       34.32%
2       87.29%

I can enter the statement "=A1*100" in the B1 cell and derive the numeric
value 34.32.  Extending the formula down the B column converts these data to
numeric, I can do a variety of calculations, and the world is a wonderful
place.  However, I need to import these data into Access.  Access doesn't
import calculated fields.  So, the question is, how can I convert from a % to
a number field type that would allow me to import into Access?

All help is appreciated and welcome.

Regards,

Paul Roeth

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                  http://freepctech.com/downloads.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG