type conversion failure

[Sonja]

I am trying to transfer spreadsheet data to an access 2000
db. I need one of the fields to come over as a number
field but always get a type conversion failure unless I
allow it to come over as text. All the entries in this
field are numbers, When I try to run a calcultation on the
field, I cannot due to a type conversion failure.

 

[Alexandre Augusto [MSFT]]

Hi,

It very possible you have a non numeric data in your spreadsheet. You can
copy & paste the data from the spreadsheet to the Access table. Convert
the column (field) with the 'numeric' data. Access will generate a table
with Conversion Errors. Look at that table and find out what column (field)
has the incorrect data.
Another tip: if your 'numeric' data is on a TEXT field try use conversion
FUNCTIONS when doing calculations.

regards,

--------------------

Content-Class: urn:content-classes:message
From: "Sonja" <[email protected]>
Sender: "Sonja" <[email protected]>
Subject: type conversion failure
Date: Wed, 30 Jul 2003 13:30:38 -0700
Lines: 6
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcNW2W/xQTf+LKkHSfO62GJEMWLUTQ==
Newsgroups: microsoft.public.access
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.access:22923
NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
X-Tomcat-NG: microsoft.public.access

I am trying to transfer spreadsheet data to an access 2000
db. I need one of the fields to come over as a number
field but always get a type conversion failure unless I
allow it to come over as text. All the entries in this
field are numbers, When I try to run a calcultation on the
field, I cannot due to a type conversion failure.

Alexandre Marins Augusto
MCSE, MCSA, CLP, CLS
Microsoft Corp.
--

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.