SQL Code Access Database add record

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

Hey guys

I am new to this and want to figure out how to add a line to my database.
It is located on C:\Employee Database.mdb

I have created a sample database called Employee Database.mdb. My table is
called Employee Database. The columns in it are as follow:
ID Employee, Name Employe ID, Password, Email, Employement Type, Employement
Status, Access Level, Hire Date, Department, Supervisor, AD

I have a spreadhseet called TEST.XLS located in C:\TEST.XLS
WHat is the code I need to make it add a new row with the value "Test" in
each one of the columns?

Am I even in the right group?
Thank you

Todd Huttenstine
 
Todd,
Please select one news group to send your questions. Many of us cruise
through many of the Access NGs so we are bound to see your question. If you
don't get an answer after a few days, consider posting it to a new news
group or rewording and starting a new thread. I replied to this question in
another NG.
 
Back
Top