Exporting table from access to text file

[narendrabr]

Hi,



Please help me on exporting table from access to text file.


Please help me on exporting table from access to excel

Thanks,

[alansidman]

To export a table to excel. Look here http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

To export a table to a text file look here: http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[narendrabr]

Hi,

How about if I right click on Table and export and then text file?

What steps I need to follow from there?

Thanks

[alansidman]

Yup! That appears to work also. Just follow the wizard instructions as you do that. You could also use the Ribbon, External Data, Export and follow the wizard. The links I provided were for automating using VBA.