how to convert Access 2007 table to sql server 2008

[rdeshpa]

I have downloaded the sql server migration assistant(SSMA) has suugested by many people,but unfortunately I am not able to get the lincence key for SSMA.
I have windows Live ID as suggested by Microsoft to get the key,but I am not able to get on the next screen after I login to windows Live ID.

Any body facing the same problem.I am stuck??I dont know how to use this tool.Is there any other way to convert Access 2007 tables to Sql server 2008?As we all know the Access 2007 upsizing Wizard does not work.
Thanks

 

[HiTechCoach]

You can always do it manually with SQL.

 

[bitse]

Use SSMA migration tool

 

[stonemethew]

I am giving you to some advice to convert the Access table into the SQL Query,
Converting DataTypes

Access: CINT(value), CDBL(value), CDEC(value), CSTR(value), CDATE(value), CBOOL(value)
T-SQL: CONVERT(DATATYPE, value) -- or -- CAST(value AS datatype)

Conditional Expressions

Access: IIF(Condition, ReturnIfTrue, ReturnIfValue)
T-SQL: CASE WHEN Condition THEN ReturnIfTrue ELSE ReturnIfFalse END

Working with Date Literals

Access: WHERE SomeDate = #1/1/2005#
T-SQL: WHERE SomeDate = '1/1/2005' (this is an implicit conversion from a string to a date)

Creating new Dates

Access: DATESERIAL(year,month,date)
T-SQL: Use the Date() function- there is no quick easy way to do this in T-SQL