Critique, advice, help, what have you...

[Gringamuyloca]

...as you can tell from my attachment, I am in desperate need!

I have a pretty good idea of where I want to end up, just not sure how to get there.

The need to standardize the language for input is needed for accurate reports.

I have turned my lists into tables in excel... but how to I make the journey to database?

All help much appreciated!!

gracias,

 

[llkhoutx]

I didn't look at your file.

Docmd.TransferSpreadsheet allows you to import and export.

 

[RodgerDJr]

The first step is to make sure that you have all your tables setup correctly. Have you done this? You said list, but do you mean tables?

You want to make sure that you normalize your tables meaning you only have fields in the table that pertain to the table you are dealing with.

Example:
Demographic information.
Table Name: USERS
USR_ID – Auto Number
USR_LAST_NAME - Text
USR_FIRST_NAME -Text
USR_BIRTH_DATE -Date
Table Name: ADDRESSES
ADD_ID – Auto Number
ADD_USR_ID – Number (Long Int)
ADD_LOC_ID – Number (Long Int)
ADD_STREET - Text
ADD_CITY - Text
ADD_STATE - Text
ADD_ZIP Text
Table Name: LOCATIONS
LOC_ID – Auto Number
LOC_NAME – Text

In the above table I have split out address so I could have more than one address for each user. If I did not split this out like this I would have to add a filed in for each different address or I would have to add the user in again for each different address. Does that help?

Once you have this all setup then we can move on to the form and add a drop down (Combo Box) to your form so the users can select from a “list”.

Rodger

 

[MagicMan]

Two answers:
1) If you intend to use Access for all future data entry, then the post "Docmd.TransferSpreadsheet allows you to import and export. " is correct, or if your only doing it once ... On Access .... select External Data...Select Excel...and the wizard will walk you through the rest for the top option...Import source into a new table.
2) If the data you have will always be from spreadsheets, and all you need Access for is the reporting. Select External Data...Select Excel...the third option is to Link to datasource. This will create a table(s) in Access that is/are linked to your spreadsheet(s) and reflects the changes in your spreadsheet. It will not accept changes in Access.

From the looks of your Jpg, it appears you intend to use Access in the future. In that case, you have to import the 9 tables to Access one time. Using the externnal data, Excel, Import to table 9 times is most likely what you want to do.