Access ODBC problem: Excel cannot get float columns

S

syborg

I need some help

I'm trying to get Access external data from an Excel workbook, using
the MS Query feature.

Everything is ok except when I try to fetch some tables that ODBC
refuses to get data from. The error message tells that the MS Access
ODBC driver doesn't allow some columns to be transmited because of its
number of characters.

The most strange thing is that I can see the data from MS Query
correctly, but I caannot get it back from Excel.

After some tries, I thing it occurs only with real typed columns.

Can anybody help me?

I use Windows XP Home + Office 2000 spanish version.

TIA and Best of all,

Marcel Massana
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top