I have this macro in an Access spreadsheet…it performs the following tasks:
1 -imports a text file called “disco.txt” into a table called “Disco”
2-imports the same exact text file into a second table called “disco_temp”
3-exports the “disco_temp” table to a spreadsheet.
4- delete the “disco_temp” table.
Step one works beautifully.
Step two errors, with the claim that “Field F1 does not exist in destination table Disco_temp. Microsoft was unable to complete the append operation.”
Since step one and two are identical in all respects with the exception of the table name that the file is imported into, does anyone have any idea why the first step would work and the second one would fail? The table doesn’t even exist yet–of course there is no “field F1”. Neither is there in one in the table created in step one, but that seems to work.
Even more perplexing to me is that afte I close out the error message, there is in fact a table called “Disco_temp” with data in it. Anyone out there got any guesses?