Changing the Data Type after importing an Excel sheet

[splendidmonkey]

Ok then here it is I am importing a Excel sheet into access then reformatting it. But one thing I need to do is after I import before the reformat is I need to change the data type on one row from number to text using ether some code or a macro as it needs to be automated.

Any idea’s

Jez

 

[RiverGuy]

I would link the Excel sheet directly. Then make the table structure locally how you want it. And make an append query to copy the data from the linked Excel file into your local table.