Showing posts with label stumbling. Show all posts
Showing posts with label stumbling. Show all posts

Friday, March 23, 2012

Import Excel to SQL using Access Project

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?

Take a look at this article

http://support.microsoft.com/kb/321686

sql