|
-
Feb 7th, 2001, 12:55 PM
#1
Thread Starter
Addicted Member
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"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|