Search results

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...