Can a Pass Through query be made to retrieve all results in plain text?

[dhartley]

I'm running a pass through query against a database and then using a make table to save the results locally in access.

One of the issues I'm facing is that access is changing the data type, e.g. dates are automatically formatted and NULL values are not being shown. Is there a way to stop access from automatically doing this, e.g storing it in a plain text format or something similar?



Thanks

Dave

[dhartley]

Sorry to bump this, but can anyone help or is the answer no?

[John_G]

Hi -

When is access changing the datatype, when it gets the data from the external database, or when you run the make-table query? From what I can see, the pass-through gets whatever the external DB gives it, so when you run the make-table that is what it uses. One thing you could do is create your local table as you want it to be, and then use an Append query instead of a make-table.

What do you mean when you say Access is reformatting dates? In Access, the format of a date is for display purposes only - internally it is always the same. If it is changing the dates, that's a different issue entirely.

When you say "null values are not being shown", what do you mean by that? Access shows nulls as blanks by default - if you what to explicity see "Null" (for example), you would have to format it that way in a query.

HTH

John