I have the following code,
Code:
DoCmd.TransferText acExportDelim, , szQueryName. szTempTextFilePath, True
which takes a query with many joined tables and exports it to a fixed width txt file, and after that a mailmerge is performed using the txt file.
I would like to be able to reverse the process, take the txt file and import it into an access database. I haven't yet been able to do it manually successfully using the wizard, and as many tables are involved it seems it is a complicated process.
Any advice on step by step approach to get me going?