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

Popular posts from this blog

matlab - error with cyclic autocorrelation function -

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

c# - What is a good .Net RefEdit control to use with ExcelDna? -