I am trying to import a spreadsheet in excel into an existing table in my DB. Or into a new table. I keep getting a generic error msg stating there was an error and it couldn't import..no specific reason though.
I have named the excel fields exactly as the DB fields. I have two copies..one with underscores (i.e. Provider_Name) and one without.
I have kept the excel file name the same as the DB name and I have renamed the excel spreadsheet. I have tried renaming the DB table aswell. Nothing seems to work.
Is there something I am missing?
*I am not familiar with VB..so any answers will have to be in simple terms.
I have run into a similar problem and think I have found a fix. The problem we have is (I think) related to having Access XP and 97 installed on the same machine. Basically one of the DLLs wasn't registered to the newest version.
Additional thought... the import into Access makes assumptions about data types.. for example, if the other field you are trying to import is a Provider Number, and your existing table has this as a data type of text, then you could get an import error as Access tries to import it as a number.