Template Wizard (Excel)

[Nitibob]

Hi all,

I have asked this question on the office forum but been told you guys might be able to help

I have an excel form that has various calculations and subsequent percentage formats that I would like to export to a table in an Access Db. Using the template wizard seemed the best way - BUT it imports all the fields as text (i have set up all the excel cells with the correct formatting)...is there a way around this.....

or do i need to do something different

Hope someone can help