Hi Everyone,

I am hoping one of you experts can help me with a problem I am having with my database.

The problem is as follows :

I have imported a .xls spreadsheet into my database using the DoCmd.TransferSpreadsheet command in Visual Basic.

This works fine and imports the data into a table called "Temp."

However the Field Size and Format and Decimal Places of a few of the imported fileds need amending.

I need to amend the field [Date] so that it's 'Data Type' changes from 'Text' to 'Date/Time ' and it's format becomes 'Short Date'

I need to amend the field [Eng] so that it's 'Field Size' chnages from 'Double' to 'Long Integer', it's format changes from 'Blank' to '#,##0' and it's 'Decimal Places' changes from 'Auto' to '0'

Any ideas what the code in VB should be to amend these fields in table "Temp"?

As always, any help will be greatly appreciated.

Many thanks in advance

Stu

Set up your main table, if it isn't already, with the correct datatypes. Then, use an Append Query to move the data over. You can set all of the formats within the query using conversions such as CLng([YourFieldNameHere] to convert to a Long Integer, etc.