By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Tab Delimited Text Files

P: n/a
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 ?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1

Jan 3 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ?
Jan 3 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.