Tab Delimited Text Files

Tab Delimited Text Files

am 03.01.2008 04:02:07 von u18648

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/Forums.aspx/databases-ms-ac cess/200801/1

Re: Tab Delimited Text Files

am 03.01.2008 09:08:37 von Allen Browne

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" wrote 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 ?