Import Excel to SQL using Access Project RRS feed

  • Question

  • Sorry if this is the wrong forum for this, but was as close as I could get.  I am an amateur stumbling thru this to "learn by doing".  I am trying to set up an access front end for a SQLExpress database, currently all local for experimenting.  Trying to import Excel data to a table in the database, using Access "get external data" function.  I get errors and the data wont import. Error message won't give me a clue to what is wrong. All fields are named the same. If I convert the excel to a csv or tab delineated, it imports correctly.  Just not the excel.  Any ideas?
    Saturday, October 21, 2006 9:31 PM