load data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file which looks like this in excel

Dept PayType Amount
2312 OT 500
reg 1000
vac 10
ss 5
2566 ot 5522
reg 42
vac 565 etc
2556 reg 10

Any ideas in automating the load process?

Thanks
 
I have a file which looks like this in excel

Dept PayType Amount
2312 OT 500
reg 1000
vac 10
ss 5
2566 ot 5522
reg 42
vac 565 etc
2556 reg 10

Any ideas in automating the load process?

Thanks
Click to expand...

If you're loading it into Excel, you may want to ask this question in
a newsgroup which supports Excel. This newsgroup is for Microsoft
Access.

If it's in Access, I'd suggest having two tables - a table of
Departments and a pay table. You could base a Form on the department
table, and a Subform on the pay table; on the subform you'ld have a
Combo Box for Paytype and a textbox for Amount.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top