|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 1st, 2009, 02:45 AM
posted to microsoft.public.access
|
|||
|
|||
Access 2003 Table Analyzer
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. -- New and Confused 
|
|
#2
July 1st, 2009, 10:06 AM
posted to microsoft.public.access
|
|||
|
|||
|
Access 2003 Table Analyzer
Tom,
See if the Excel to Access Converter Utility will do this for you at - http://www.rogersaccesslibrary.com/f...87 231e28cb7d 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. On Tue, 30 Jun 2009 18:45:01 -0700, Tom wrote: 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.
|
|
#3
July 2nd, 2009, 02:10 AM
posted to microsoft.public.access
|
|||
|
|||
|
Access 2003 Table Analyzer
Peter, Thank you very much for the input. I've downloaded the program and
will give it a try in the next few days. -- New and Confused "Peter Hibbs" wrote: Tom, See if the Excel to Access Converter Utility will do this for you at - http://www.rogersaccesslibrary.com/f...87 231e28cb7d 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. On Tue, 30 Jun 2009 18:45:01 -0700, Tom wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
