exporting table through vb without strings having quotes 
Author Message
 exporting table through vb without strings having quotes

Quote:

>anyone? easy to do manually, just having trouble finding
>vba that will allow this

Use the TransferText method.

One trick to using that is to first export some sample data
manually.  As you work your way through the export process,
you will specify various options such as field deliminators,
quotes, etc,  this stuff is collectively know as the
import/export Specification and can be saved with a name so
the process can be repeated easily.  The specification name
can also be used with the TransferText method to duplicate
the actions you performed manually.

This is a fairly large topic so be sure to read Help for all
the details.

--
Marsh
MVP [MS Access]



Sun, 15 May 2005 23:47:50 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Exporting Strings to a TXT File without Quotes

2. Write Strings To File Without Quotes??

3. Q: Strings Without Quotes

4. Appending a string to the end of a file without any quotes around it

5. Open a doc, grab a range without having the whole doc being tabled

6. Quoting "Quotes" in a string variable

7. Quote in quoted string ?

8. VB project using .MDB without having Access?

9. Calling A C++ DLL from VB without having Declare Statements

10. Passing strings with quotes into a stored procedure from VB

11. VB/SQL Server 6.5: quoted string

12. Passing strings with quotes into a stored procedure from VB

 

 
Powered by phpBB® Forum Software