CSV file and import macro

[Jose Lopes]

I’ve created a macro to import a CSV text format file. However, even
including the format predefinitions saved and setting them in the right
parameter, the imported table is not exactly the same and I don’t know why.
I’ve checked and rechecked and the difference from manual imported table and
a macro imported table are none e.g. fields' format, no parameter key,
exactly the same data inside the table… I don’t know what else. When I try to
query the macro table with another table I have the results are different.
What can I be missing here?

 

[Steve Schapel]

Jose,

Can you give some more details or specific example of what you mean by:
"When I try to query the macro table with another table I have the
results are different"?

 

[Jose Lopes]

Hi Steve,

I have another post here in Macros but you will have to excuse me… I don’t
know how to link you to it. The subject is “Query from two tablesâ€. Basically
I’m trying to compare a bigger table with a smaller table, TABLE1 and TABLE2,
so I’m using the Nz function for nonexisting values.

My TABLE2 data has usually two or more rows per product number because the
product can be stored in one or more locations in the warehouse. I have to
sum the location’s total from a LOCATION field to compare the two tables and
I’m using Nz(Sum(TABLE2.LOCATION), 0) AS TABLE2_Qty .

I don’t know if this way of using the Nz function is “bullet proof†but when
I try to automate the process of import the CSV file, although my table is
apparently exactly equal to a manual imported one, the imported values of
TABLE2_Qty are just doubled!

This wasn’t happening before so I’m back the manual process until I find the
problem. By the results I'm getting i'm assuming the problem to be in the
automation process.

 

[Jose Lopes]

I forgot to mention that I'm trying to import to TABLE1 from the CSV file.
TABLE2 values come through ODBC directly.