Recent content by newbie95670

I have a Make Table query in Database A that makes a table in Database B. However, Database B is password protected with the password "the". I have tried to use the Dest Connect Str in the Make Table Query by entering "the", PWD="the", ;PWD=the!, ;PWD="the", all have failed. Each time I get...

Thank you!!!!! Thanks so much for your time and help. Jim

Thanks for taking the time to post, I've tried that and still get the 16,384 records. I've tried rebooting to clear and that hasn't helped either. Thanks, again for your time. I hope there are other ideas. Jim

I asked this question on the Access forum but to no avail, so I'm trying here. The problem is whenever I import data from Excel to Access it limits the number of records to 16,384. The worksheet has over 20,000 records. If I split the worksheet in half, it imports all of the records without a...

Thank you BNPMike for your response. I do have access create a new table and there is no error table created, it thinks that it has imported all of the records. The data is simple text and creates a text formatted field when imported. I think the problem might have something to do with the...

I am importing data from Excel to Access97. When I do so, I only get 16,384 records from a source of 22,198 records. I also notice that whenever I use the analyze with Excel, the output is saved to an Excel 5.0 worksheet. I'm guessing the two issues are probably related and are in the setup...