Discussion Locked

Who has query- macro skills in MsAccess

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to import a spreadsheet from excel into access. But the spreadsheets come in text and some of the fields need to correspond to numbers put into other tables. I didnt write the database, i just have to now work in it. Is there an easy way i can write a query or macro to reference the spreadsheet or a table and convert multiple fields to corresponding numbers already set in other tables?

example: spreadsheet will have "entered by" and "form" column. Rows will have names like "Joane", Jeny", "Debra", and forms like "spreadsheet", "Fax", email". Debra =1, joane=2, ...etc, spreadsheet =10, fax=12...etc all listed in other tables.

thats as elementarily clear as i can make it.

PLease help!!!

2 replies

by bristar

I'm not sure exactly what you are trying to do. Although, if you are referencing something like names to a number, you'll need to establish the relationship in another table in your database and then link them via relationships. You can then use aquery to display the corresponding numbers to the name.

If you want to provide an email address, you can email me your files so I can help you build it.

by djoubert

my email address if not listed here already is djoubert@earthlink.net and any assistance voluntarily provided will be greatly appreciated

This discussion is closed to new replies.