On the External Data tab of the ribbon, in the Export chunk, click the Text
File icon.
If you are having trouble seeing TransferText in macro design view, depress
the Show All Actions icon on the Show/Hide chunk of the Design ribbon.
You can also use TransferText in code. If no code runs at all, specify your
database's folder is a trusted location under:
Office Button | Access Options | Trust Center | Trust Center Settings
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"destinman via AccessMonster.com" <u18648@uwewrote in message
news:7da2f3c210165@uwe...
>I recently purchased the MS Access 2007. I have used MS Access 2003 for
years. I need to transfer a table in a Tab Delimited Text File format
and
do not see where2007 has a TransferText function which gives you the tab
delimited option. Is TransferText not available with 2007 or have I not
looked deep enough ?