Queryman - Export to Access error.

[unifex]

I've just come across an issue when exporting the results of a query into MS Access.

I have two address tables in very similar formats except the 2nd one having several more columns.

When using Queryman to export records from these tables into access tables the first returns everything fine however the 2nd has the lastr 2 columns unpopulated.

Having checked the data directly i can see that they should be filled and that in fact i can export the table to a text file fine and have it fully populated.

Can anyone help pls!

Unifex

 

[bkj123]

Hi Unifex

What are the formats of each of your fields? Please list them in order so I know which are the last 2.

Thanks.

 

[unifex]

The first of them is a decimal(10.0) and the last is a char(3). I have successfully read in both these fields in other tables as they are both key values.

Forgive me for not listing the rest of the fields as there are plenty but basically they are either decimal (5.0) or some length of character.

Thanks for your help.

unifex