Recent content by DouglasMacArthur

I'm not exactly sure why, but the problem wasn't the code, it was one of the fields. It was in both tables, but for some reason when I excluded it from the query everything works perfectly. Luckily, I don't even need that field (for reference, it was an "attachments" field type). Thanks for the...

I made the thread earlier where I ran into this problem, but my initial issue that the thread was about was solved so I figured I'd just start a new one to solve this issue rather than complicate things. Anyway, I need to append a temporary table to a master table, then wipe the temporary...

Ah ok, I understand what you mean now, thanks for the thorough response! EDIT: Most of this seems to be working ok, however my append approach doesn't seem to be working. CurrentDb.Execute "INSERT INTO mainTable SELECT * FROM Table1" CurrentDb.Execute "DELETE * From Table1" The delete...

I know, I was just trying to be as clear as possible :o Yes, I'm using TransferSpreadsheet. So basically, I use one table for the data I have and another for the source field and stitch them together, or one table overall? I originally was doing it the latter way, but I figured in order to do...

Hi all, I'm new to this forum and relatively new to VBA, so from what I can tell, this problem should be pretty simple to resolve. Basically, I need to read in a bunch of excel files to a single database table and add a column that contains the name of the file each entry originated from. My...