how can i export to text tab delimited file a table from MS Access?
Printable View
how can i export to text tab delimited file a table from MS Access?
Hi,
Call the database and retreive a recordset.
When you have the recordset do a for each field in rs.fields loop and put a tabulator between fields, then when you get the next record you need to add a chr(13) for enter and next record.
Does this make sense? I'm ill today and maybe delirious!!!
André
hi
your ill but youre surfing the net!!!...NET ADDICT!!!
ha ha ha just kidding...
anyway, ill tr it. thanks for replying.
P.S.
do you know how to put a hot key to a graphical command button. I wont be able to use the ampersand cos i didnt put any caption on the command button. i put picture instead (but i need to have a hotkey for it)
thanks
set the form's keypreview property to true, then test for the hotkey in the forms KeyUp/KeyPress event.