importing numbers from access into sql with different format

I am importing a column from access to sql 2005 but the numbers in the column are formatted differently:  e.g.
I would like all to have decimal 2 places.  the sql column is money format.  thanks
Who is Participating?
Aaron TomoskyConnect With a Mentor Technology ConsultantCommented:
You can make the column a decimal(18,2) format or you can just cast it when you use it.
Select cast(numbercolumn as decimal(18,2)) from table

If you do that you could store it as a varchar or whatever.
kamindaConnect With a Mentor Commented:
I would suggest you to import data to SQL Server's varchar column with the required length. And then covert it to money within SQL Server by casting it. This way you wont loose any data due to formating (At least it is minimal)
Gustav BrockConnect With a Mentor CIOCommented:
Leave the numbers "as is" and format them to your liking when displayed.

bar0822Author Commented:
I imported as is and imported into money column and now have 4 zeros after decimal point but will leave as is unless they want it changed.  I'll use a cast in select.  thanks for the replies.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.