Format spreadsheet from Access vba (1 Viewer)

[polina]

Hi,

I want to do the following:

Before I import the excel spreadsheet into Access table, I want to be able to access that spreadsheet and change the data type of some columns in it. Since I don't want my user do it manually, I am looking for the VBA code to solve this problem.

Please advise.

Thanks.

 

[Tim K.]

The easiest way, at least to me, is linke the Excel file to Access and then use an append query to your target table. You don't have to worry about the data type.