Formatting Fields in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to format the fields in two separate tables that I've linked to Excel
spreadsheets so that they will match in a query.

The Excel spreadsheets were created differently, 1 from a report engine and
then saved as Excel with format, the 2nd originally created in Excel.

I've tried to change the formatting to text in the 1st file from the report
engine however no matter what I get the "no match type expression error
message".

Does anyone know how to get around this? I have to link the spreadsheets
and the format in the original Excel spreadsheet has to be 'text'.

Thanks.
 
You have not told us specifically what the difference is or how you want to
format the data. What are the two fields in question? How is the field
formatted in table1 and how is it formatted in table2? What is an example
of a few field entries and how do they vary from one field to the other?

A few specifics, please.
 
Okay. Table 1 shows an Item Number such as 'KYOK484LC' and a Vipkey such as
'05513595901'. This table is formatted as text to keep the '0' in front of
the digits. This data is scanned into Excel for inventory counts.
Table 2 shows an Item Number and a Vipkey, the same as Table 1 however it is
formatted as 'General' from the reporting engine I use, then saved into Excel
with format. Even when I attempt to format it to 'text' it doesn't carry into
Access in that format.

The error message I get is 'Type mismatch in expression'
When I review the field properties in the Query Design the fields from Table
2 are blank as to format type.
 
Back
Top