Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: newbie95670
- Content: Threads
- Order by date
-
"Not A Valid Password" with Make Table Query
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...- newbie95670
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with import/export between Access97 and Excel
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...- newbie95670
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Partial imports from Excel to Access97
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...- newbie95670
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
