entering records

[Susan]

Hello, am new to Access. Have a project and Community
for tables NA. Hope someone can answer.
I am entering 6 digit ID#'s for employees. Have 800
employees. Will be entering a calendar year for each
employee. EX: ID 112233 will have 365 records Field 1=
ID# Field 2 =year Field 3 = month and Field 4 = day. In
the end, total records will be more than 25,000.
My question is: What is the fastest way to enter this
info? Copy, paste and drag don't seem to work.
Thanks to everyone for your help. You all are the
greatest.

Susan

 

[Aldo]

Hi Susan,
Your issue has 2 solutions to it. I think the second
solution would be an easier one for you.

1.. To write some code which would perform the task
programatically.
2.. To create an excel sheet with the required data and
then import it into access. In excel you can use the
functionality of copy, paste. Once you have the excel
sheet ready, import it from access.
How to import the excel file from access:
--open the access datbase
--Click on the "file" menu -> "get external data" -

"import" -> on this an import dialog box will open

--Select the file type as "Microsoft excel" and select
the excel file you created. Click on import
--On this an import wizard will open up which is self-
explanatory. Follow the steps in the wizard and you will
have the data into a table in the database.

Email me if you have any difficulties in doing this.

Regards,
Aldo

 

[berni]

aldo,
this would be great if you can hit me with the code as it
will be also of a great benefit.