convert excel data

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

Guest

I am trying to convert an excel spreadsheet that has many columns of data
with the same type of information. Employee Name, Payment Amt for June,
Payment Amt for July, payment amt for August........ etc. I want to convert
it to an access data base that has employee id, Payment June, Amt per row.
 
Marcie

It sounds like you are trying to use Access like a spreadsheet. Consider
further normalization of the data structure you'll use in Access.

For example, consider something like:

trelEmployeeAmt
EmployeeID
PaymentDate
PaymentAmt

This gives you a way to keep all the month's data, and you can query this
for Month(PaymentDate) and Year(PaymentDate) if needed.

You'd need to build a "normalizing UNION query" to load from Excel data to
such a structure. Check Google.com for "normalizing UNION query".
 
Back
Top