SQL Code Access Database add record

  • Thread starter Todd Huttenstine
  • 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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top