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 Mike Lewis 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: davegulliksen
- Order by date
-
Any chance of saving this corrupt db
I use Access 2000. I had a similar problem recently. I fixed it by creating an empty database file and doing <File> <Get External Data> <Import>. I skipped what was giving me errors, and I copied the module's text instead of copying the module itself. You could also try doing <Tools> <Database...- davegulliksen
- Post #4
- Forum: Microsoft: Access Other topics
-
How to convert (copy) data from Excel file to table in .mdb (MS Access
The easiest way would be to do <F>ile, <G>et External Data, <I>mport *OR* <L>ink Tables from the menu as apppropriate, choose the Excel file and answer some questions about the data structure, and you'll end up with the Excel data as a table in your file.- davegulliksen
- Post #4
- Forum: Microsoft: Access Other topics
-
Append from Multiple Tables to Multiple tables
Your main problem, as I see it, is that the customer's CustomerID will change when it moves from one set of tables to the other. If the customer name is unique, you can append the customer name to the existing customer table, query the name to get the new customer ID and use that to append the...- davegulliksen
- Post #5
- Forum: Microsoft: Access Other topics
