Is there a generic way to export a tables data with the text qualifier set to {none} using the
DoCmd.TransferText acExportDelim, , myTable.Name, strFile, False function? The second parameter not given can specify a export specification but I have to create one for each table in the database. All I want to do is export the data with the text qualifier set to {none} instead of the default "" around all text. I can do it by creating a specification for each table but that isn't efficient.
Thank You,
-bitwise
DoCmd.TransferText acExportDelim, , myTable.Name, strFile, False function? The second parameter not given can specify a export specification but I have to create one for each table in the database. All I want to do is export the data with the text qualifier set to {none} instead of the default "" around all text. I can do it by creating a specification for each table but that isn't efficient.
Thank You,
-bitwise
