convert scientific notation to to decimal

I am importing a bunch of data which is all in varchar format which I cast into the relevant type on transfer to the production table. One of these columns contains decimals, but some of them are occasionally given in scientific notation (3.48E-02).
I am using

CAST (v1 AS decimal(18, 13))

to do the conversion, but that seems to be unable to handle the scientific notation. Does anyone know a way around this?Try converting to float first, like this:
CAST (CAST (v1 AS float(24)) AS decimal(18, 13))

convert or transfer access mdb file to sql server

what's the easiest way to do this. i have 5 tables within the mdb file
i tried the "easiest way" shown in a website but it does not work.
the way i did it was on access(2007) > database tools tab > sql server button
it gave me an error when it ask for an login ID
i do not have any password/id..

please help
thanksIf you do not have a logon to the SQL server then you do not have the permissions to do anything to it - simple eh?|||He could be set up with windows authentication or mixed-mode security, which would not require a password.|||it's microsoft sql server management
when i open it.
it will show a box to connect.

server type is Database Engine
Server name is Mackenzo
auth. is windows auth

yes i have a username without a password which is mackenzo/mackenzie

what can i do??