Access 2003 Table Analyzer

T

Tom

As a way to learn about access I have imported my Music/CD catalogue from an
excel sheet into acces. When I run the table analyzer to split my original
table into multiple related tables to reduce redundancy I get a pop up
"Correcting typographical errors for table". Most appear to be for non
duplicate entries.
Is there any way to reduce or eliminate them, with out having to update the
"correction" column. There are hundreds for each table.
 
P

Peter Hibbs

Tom,

See if the Excel to Access Converter Utility will do this for you at -
http://www.rogersaccesslibrary.com/...?TID=183&SID=e81a164e2314187z3e8587231e28cb7d
The built in Access Table Analyser generally does not do a very good
job at this, you would be better trying to determine which tables you
need and which columns from the spreadsheet need to to be copied into
which tables. Once you have that worked out the above utility should
be able to transfer the data automatically for you.

HTH

Peter Hibbs.
 
T

Tom

Peter, Thank you very much for the input. I've downloaded the program and
will give it a try in the next few days.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

db normalization using table analyzer 4
Using the Table Analyzer 2
Pictures in an Access table 5
Split Access table into 2 1
How do I find the indices on a table in Access 2003? 4
Access 2007-Table Analyzer/Data Import Error 2
Emails from Access 2003 Table 3
Access 2003: populate combobox with CSV values from table column 1

Top