• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

HTML Table Import Errors

Q1:Importing HTML tables generates unexpected "Import Errors" messages
The Import HTML Wizard, like the Text Import Wizard, checks the values of each column for the first few rows of the HTML table. The first test is to determine if the column contains alphabetic characters; if so, the Wizard sets the Jet data type to Text. If the Wizard detects only numeric values, it also tests for a currency symbol and a decimal separator. If the currency symbol is present, the Wizard chooses the Currency data type; if not, the data type becomes Double if a decimal separator is present, otherwise the data type becomes Long Integer. If subsequent rows of a column contain entries that conflict with the selected data type, import errors occur. You can avoid most, if not all, import errors by choosing Text for the data type of all columns, then inspecting the table in Datasheet view to determine the appropriate field data type for each column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint