Dealing with MAX number of fields & ODBC

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

Guest

I have a ODBC hook to a file with way more than 256 fields. When I attempt
to link or import the table, I get the first 256 fields and that's it. If I
attempt to get the fields I want in MS Query I can, no problem.
So, can I code the ODBC hooks so i only get the fields I want? I only need
like 10 fields and the MS Query code that gets me where I want to go is like:

XLODBC
1
DSN=SouthWare;RemoteHost=(MyHostIPaddressGoeshere);RemotePort=20222;SERVER=NotTheServer
SELECT sbil1_worked.OrderNumber, sbil1_worked.CustomerNumber,
sbil1_worked.OrderEntryType FROM sbil1_worked sbil1_worked


OrderNumber CustomerNumber OrderEntryType
 
Dirtbike said:
I have a ODBC hook to a file with way more than 256 fields. When I
attempt to link or import the table, I get the first 256 fields and
that's it. If I attempt to get the fields I want in MS Query I can,
no problem.
So, can I code the ODBC hooks so i only get the fields I want? I
only need like 10 fields and the MS Query code that gets me where I
want to go is like:

XLODBC
1
DSN=SouthWare;RemoteHost=(MyHostIPaddressGoeshere);RemotePort=20222;SERVER=NotTheServer
SELECT sbil1_worked.OrderNumber, sbil1_worked.CustomerNumber,
sbil1_worked.OrderEntryType FROM sbil1_worked sbil1_worked


OrderNumber CustomerNumber OrderEntryType
Click to expand...

Do you need to do edits on the table? If not then use passthrough queries
instead of a link and then you can specify which fields you want.
 
Back
Top