If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SQL Code Access Database add record
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 |
#2
|
|||
|
|||
SQL Code Access Database add record
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. -- Duane Hookom MS Access MVP "Todd Huttenstine" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|