tag:blogger.com,1999:blog-2807403883562053852.post4371051800970723382..comments2024-03-27T08:40:31.785-06:00Comments on Clayton Cramer.: I Should Have Done This At the StartClayton Cramerhttp://www.blogger.com/profile/03258083387204776812noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2807403883562053852.post-644642929144413572018-10-04T08:27:17.048-06:002018-10-04T08:27:17.048-06:00It's very easy to import Excel files directly ...It's very easy to import Excel files directly into Access.<br /><br />If you decide you want to turn a flat file into a relational one, you can either import the table multiple times and delete the fields you don't want, or use a "make table" query to build your relating tables.Karlhttps://www.blogger.com/profile/09767954910569442805noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-45659319054136845322018-10-01T09:58:30.956-06:002018-10-01T09:58:30.956-06:00Have you thought about installing/using MySQL?
htt...Have you thought about installing/using MySQL?<br />https://dev.mysql.com/downloads/<br /><br />You could export information from Excel to a text file, and then import to a database (after you setup your tables). Just a suggestion.jnvm34https://www.blogger.com/profile/01823955176282111412noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-52814918726721025992018-10-01T09:14:32.715-06:002018-10-01T09:14:32.715-06:00If you're not designing a set of relational ta...If you're not designing a set of relational tables, but just a flat-file analog to your spreadsheet, you won't have to learn much besides the querying mechanism. I do a lot of work with Access and VBA for my own projects (like a compilation of information about the Battle of the Bulge so that I can search for units, dates, places, people, etc.) so if you have any questions, just ask. I'm also right down the road from you in Hidden Springs.DryCreekHistoryhttps://www.blogger.com/profile/16270400810526252348noreply@blogger.comtag:blogger.com,1999:blog-2807403883562053852.post-87751738163146389872018-10-01T07:11:30.833-06:002018-10-01T07:11:30.833-06:00If you know SQL, and don't know Access, why no...If you know SQL, and don't know Access, why not use a SQL database?<br /><br />MySQL is free and easy enough to install.jdegehttps://www.blogger.com/profile/01495457567906071678noreply@blogger.com