The world (andf excel and access in particular) is full of strange things
Try this (you never know) in your excel add a column (don't hide it or do
anything "strange" just yet.
Add the most basic thing that excel will do to get the currency accross into
this new coloumn (don't cut it but use it as a source)
So if yur currency is in cell A1 just put =[A1] in the new column and copy
down. Format this new column as a number
Import this into a "new" blanc table with just one field called SchwimmsNumber
Don't put any primary fields or anything else in the table. Keep all the
"strangeness" out of the way for now
Does it work now ?
--
Wayne
Manchester, England.
Schwimms said:
It's funny, and I don't understand the issue. The dollars in excel look like
this 13720... Checking format on cells...this is the problem, the format of
the cell is this. [$-1010409]$#,##0.00;($#,##0.00). I have fixed the macro on
my excel file to change the dollars to a general number format, I tried using
a normal dollar format but it didn't work. Thanks for the idea Wayne.
Wayne-I-M said:
Why is the data being deleted.
Is the field you are importing to set as currency ($)
Can you do a very simple =[##] in excel format as number then import then
import this into a currency field in access
??
There are a number of work-a-rounds but the basic fact is the field should
not just disappear
--
Wayne
Manchester, England.
:
Huh? I'm importing into access, then I import back into excel. I'm just
describing my issue. I know this is for access, I am writing in here because
my issue occurs in access.
:
On Fri, 20 Jun 2008 06:25:01 -0700, Schwimms
Are you importing into Excel? This newsgroup is about the Microsoft
Access database product.
-Tom.
I have a column that is imported on a macro and the column is dollars,
although when I import it in as dollars the whole column is deleted. So i
import it in as text, the next step for my file to be updated would be to go
to EXCEL and refresh my data on the access query. When the data is imported
into excel it looks like this "$25,408.00" with the quotations. I dont want
those quotations. What can I do?
