SQL Access Database Add record

[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

 

[Duane Hookom]

Few comments based on making hundreds of mistakes:
1) I think you want to add a "record" not a "line"
2) using "database" in an mdb file name is a bit redundant. A simple
"Employees.mdb" might be better.
3) Consider a naming convention such as those suggested by Tony Toews
http://www.granite.ab.ca/access/tablefieldnaming.htm. Consider naming your
table tblEmployees or similar.
4) I would not use spaces in field names
5) When I want to add sample records to a table for testing, I will often
use Excel to enter, copy, or increment "rows/records". You can then select
and copy the Excel range, open the Access table (same number of
columns/fields), go to the bottom record, and select Edit|Paste Append.