vba - Rename Field Name to Illegal Name & Output to .fac file -
good day
i have table of following format:
heading1 heading2 heading3 data1 data2 data3
current vba code used output table comma delimited text file:
docmd.transfertext acexportdelim, , "table", "c:\output.txt", true
i require table output comma delimited ".fac" file file type unique application called "prophet". unable using current code. if change ".txt" ".fac", access produces following error: "cannot update. database or object read-only."
i require "heading1" changed "!2". cannot change "heading1" "!2" in datasheet view since special characters not allowed in headings of tables within access.
any help/guidance appreciated.
regards josh
Comments
Post a Comment