-
I wish to export a Excel spreadsheet or a delimited text file from ONLY PART of a table in a MS Access database using the DoCmd object in my VB program. Can be possible?
Sample Data in the Database table (Price):
<ticker>;<name>;<date>;<open>;<high>;<low>;<close>;<volume>
0001;CHEUNG KONG;02/05/2001;0.0;103.0;101.0;102.0;3103880
0001;CHEUNG KONG;02/06/2001;0.0;109.0;107.0;108.0;3203880
0002;CLP HOLDINGS;02/05/2001;0.0;38.20;37.50;38.0;2672407
0003;HK GAS;02/05/2001;0.0;11.25;11.0;11.15;4514929
:
:
I wish to export the tuples:
SELECT * FROM Price WHERE ticker="0001"
-
One possible way to do that is to query your database for the specific data you want and save that data to a dynamic array. Then you can loop through the array and process it.