Run Time Error 31550, need Temp Table

[Heatshiver]

I have been problems with error 31550, and have a previous post about it. But one of the ideas was to create a temp table.

I was thinking I could have a temp table created, store the data there, have it checked against the current data, then only important what data is not present in the database. Does anyone know how to perform this in VBA? Or maybe a site or thread that would give me some insight?

 

[Heatshiver]

Never mind everybody. After hours of trying different things I was able to somewhat suppress the error by presenting my own message.