I appreciate the reply!! I managed to get a hold of someone who know more than me about it, and that lives a lot closer to the site. He went...

Anybody have any ideas on this?? I was hoping it would be something simple that many people could help with. Any help would really be appreciated.

Thanks a lot, I appreciate your help.

Ok, so when I drill down in Windows Explorer to the physical file, the size of it there is not reflecting the amount of data in it (meaning it is...

I will try that, thank you. I think Union is what I was looking for.

Ok guys, you got it, I was wrong. Thanks a lot!!!

Yeah, I don't get it either. Tables 1 and 2 have 1007 related rows out of a total of 23056 rows in Table 1. I'll keep playing with it. Perhaps...

That appears to delete everything from the tables, not just the related rows...

Excellent, I'll try it, thank you!

Thank you.

I'd like to investigate the last option you suggested. I do have the .xlsx driver from the first option you mentioned, but that just isn't working for me. When...

Thank you.

I'd like to investigate the last option you suggested. I do have the .xlsx driver from the first option you mentioned, but that just isn't working for me. When...

I appreciate that, but I don't have a connection string to give you. I am never able to complete the configuration to begin with. As for the error, it's simply...

Thank you. I looked and did not find "Microsoft.ACE.OLEDB.12.0". I do see "Microsoft Office 12.0 Access Database Engine OLE DB Provider". And I did read the article that said to...

I have a similar situation. I have a form with only 6 fields in it. All the fields actually work well except for 1 date field. When we enter that...