Hi,

I have a form created in Microsoft Word that I populate with data from either and Excel Worksheet or Access Table. Some the data columns are formatted as currency and percentages. Using Excel and the following connection string, the data is returned in the correct format e.g., 50% or $123.34

fcnConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
          "Data Source=" & strFileName & ";" & _
          "Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";" 'Excel 12.0 Xml;HDR=YES;IMEX=1
Adding the IMEX=1 results in the actual formatted data being returned.

However, with Access using:

fcnConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" _
                       & "Data Source=" & strFileName
The data loses its formatting e.g., 50% appears as 0.5 and $123.34 appears as 123.34

Is there some way to get data using ADODB such that the format of the data in the record is returned?

Thanks.