macro???

[realspido]

Hi again.
How to craete table(s) which would solve this:
Week
ending weekday Employee Hours
date

5/5/06 MON Emp.1 9.5
5/5/06 TUE Emp.1 9.5
5/5/06 WED Emp.1 9.5
5/5/06 THU Emp.1 9.5
5/5/06 FRI Emp.1 7
5/5/06 MON Emp.2 9.5
5/5/06 TUE Emp.2 9.0
5/5/06 WED Emp.2 9.5
5/5/06 THU Emp.2 9.5
5/5/06 FRI Emp.2 7
12/5/06 MON Emp.1 9.5
12/5/06 TUE Emp.1 9.5
.....
Hours are in comma-separated file containing Employee ref.
My question is: How to get Access to automatically create records and fill
in hours from *.csv file? I have a list of all employees as separate table.
*.csv file is only for one week, so I need to generate records every week.
Is there any way to build macro which could input: "5/5/06, MON, Emp.1"
and hours from report, then create new record with: "5/5/06, TUE, Emp.1"
hours, etc....
Please for help I'm desperate!!!!
I don't know Access well; I know how to build relationships, and queries,
I'm good with macros in Excel but just starting with Access...
Thanks for your help!!!

 

[Pieter Wijnen]

Try the TransferText method
First time do a manual import & save the spec. Then you can use that as a
criteria for your macro

HTH

Pieter