Access 2002 Tab delimited export

[Tony]

Would someone please help me figure our how to do a tab delimited
export from Access 2002. I must send my data in that format.

I have read and tried several things. Excuse me while I blow off
steam. There is no "Advanced Tab" in the 2002 export wizard nor is
there any apparent way to setup a tab export specification. When one
does an text export there is no option to export in tab. And the rtf
format does not produce a tab-delimited file, it produces an RTF file
that appears tab delimited in a word processor.

Any suugestions? I'd like to do this via VBA?

Thanks.

Tpny Jenkins

 

[John Nurick]

Hi Tony,

Please forgive this plonking explanation; we need to be sure we're both
thinking of the same things. In Access 2002:

- Select a table or query in the Database window.
- Right-click and select Export...
- You should now have something that looks like the standard Save As
dialog, titled something like "Export Query XXX to..."
- In Save As Type, select "Text files (txt, csv, tab, asc)". Do not
check "Save Formatted". Click Export.
- You should now get the Export Text Wizard, complete with Advanced...
button.

If not, check the following. If that doesn't fix it, post back here.


If the import/export wizards don't work at all, re-register ACCWIZ.DLL

If it's one or more file formats that aren't listed, re-register the
following files
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881

 

[Joe Fallon]

Not sure why you need the Advanced button....

On page 1 of the wizard choose Delimited
On page 2 choose Tab
etc.

 

[John Nurick]

OP wants to do it via VBA, hence will need to save a spec...

 

[Joe Fallon]

John,
Doh.

You read too closely! <g>