Link between Excel2000 and Access2000 via "Query"

[Waxaholic]

I am in the process of converting an Excel database to Access and have run into a problem. I want to continue to use the Excel data until the Access database is fully functional. So, i am currently using a query to bring the data from Access into Excel to apply my excel formulas for proper output (charts, graphs, etc.). The problem i am having is that my VLOOKUP formulas have failed to work now when linked to the Excel query sheet and return a value of #NA. Is there a formatting issue when bringing in data from Access into Excel? I am at a total loss here as i cannot find reference anywhere as to why this is happening. I have tried reformatting the data on the Excel query sheet yet this does nothing. Any and all help appreciated.

Wax

 

[Waxaholic]

I figured it out. Turns out it is in fact a formatting problem on the Access side. Now i have to figure out a solution for modifying the formatting of data on the Access side.

Thanks,

Wax