|
More DB questions
I'm importing a lot of books in lit format, and the data quality is fairly low. I'd like to be able to edit data more easily, but I'm nervous about messing up the db.
For example, in the 'books' table, it's not clear to me what the 'sort' column is used for, and hos this is different from the 'title' column. The 'authors' table has a 'name' and a 'sort' column, but 'sort' appears to be unused.
The main fields I'd like to work with are isbn and series. From there, I'm fine using the gui to fetch the rest of the data using isbndb. I'm finding that I can't edit the data easily in Access, probably due to limitations in the odbc driver.
Any thoughts?
- Ed
|