Access Queries

[ydiaz72]

I imported to access a table from excel to be able to compare it with an information I have in access but i am unable to get the results for some numbers in the excel sheet had a number format I changed it to text but it still does not make the query correct. Id appreciate help on this matter.

thanx

 

[Joe4]

Can you provide more details about these fields and the problems you are incurring?

One thing to note is that if you are importing/linking data from Excel, you do not have the ability to specify the format of the fields that are coming in. One way around this is to export the data to a text file, and then import the text file into Access where you can use the Import Wizard and have the ability to specify your field formats.