P
pierre-yves.ste-marie
I do not understand why when I export in Excel some data from a query in
Access, I "loose", sometimes, not always, some data....
If I open in Access the query Query001, I have a result of 150 records.
When I run this VBA: acExport, 8, "Query001", "C:\Result001.xls", True
Sometimes, the file created in Excell, Result001.xls is perfect with the
150 records in it.
"But some other times, if I open this file, I have some data from line 15,
or 20, or..22 up to line 150. The first 15, or 20... lines in Excell are
"empty".
Then, I close Excell, andI run again in Access acExport, 8, "Query001",
"C:\Result001.xls", True, and then, I have all my 150 lines completed in
Excell.
Any reason for this annoying result?
Whith regards
Access, I "loose", sometimes, not always, some data....
If I open in Access the query Query001, I have a result of 150 records.
When I run this VBA: acExport, 8, "Query001", "C:\Result001.xls", True
Sometimes, the file created in Excell, Result001.xls is perfect with the
150 records in it.
"But some other times, if I open this file, I have some data from line 15,
or 20, or..22 up to line 150. The first 15, or 20... lines in Excell are
"empty".
Then, I close Excell, andI run again in Access acExport, 8, "Query001",
"C:\Result001.xls", True, and then, I have all my 150 lines completed in
Excell.
Any reason for this annoying result?
Whith regards