There is probably a very simple solution to this.
I have a small Access sytem which gathers data from various sources and creates a table of composite data. After checking manually the table is exported to a text file for use in a system off site. TO be compatible with the receiving system the fields are delimited with an exclamation mark (!). I my current system I have a specification and use the DoCmd.TransferText to create the text file using the specification.
I want to upsize the system to an Access Project and find that I cannot re-create the specification file to preform the export successfully.
I did try writing to a text file using the Print command but the receiving system couldn't load the data from this file. As this is outside our company finding out why will be very difficult.
Any suggestioons as to what to do would be welcome
Sandy
I have a small Access sytem which gathers data from various sources and creates a table of composite data. After checking manually the table is exported to a text file for use in a system off site. TO be compatible with the receiving system the fields are delimited with an exclamation mark (!). I my current system I have a specification and use the DoCmd.TransferText to create the text file using the specification.
I want to upsize the system to an Access Project and find that I cannot re-create the specification file to preform the export successfully.
I did try writing to a text file using the Print command but the receiving system couldn't load the data from this file. As this is outside our company finding out why will be very difficult.
Any suggestioons as to what to do would be welcome
Sandy