I am trying to connect to a MYOB (.DAT) table using the ODBC driver. I do not want to link the table to the main database I would simply like to query it.
What I have done so far is to create a query with the 'Source Connect Str' set to "ODBC;DSN=MYOB;;TABLE=MYOB.Items", and added the table and field I want to query. The SQL created is this:
FROM MYOB.Items IN '' [ODBC;DSN=MYOB;;TABLE=MYOB.Items];
Running this query, will ask for the parameter MYOB.Items.ItemName what ever I enter will be displayed for the number of records that are in the table. The amount of records its displaying is the same as there is supposed to be but the data is not the same. If anyone has any ideas I would be much appreciative.