columns to field value (Months)

[mws5872]

I have users that want to upload from excel the data for different months. Currently in access we have it already set to a column called 'months' and not 'january' - 'Decemeber' if that makes sense. How can I take it from a single entry and upload it into access as a field value. Let me know if that doesn't make sense.

 

[plog]

Is this a one time deal or do the end users want to be able to do this regularly?

If its a one-time deal I would just manually make that data importable--start a new spreadsheet and for every month bring in all the rows of data for that month and then add a new column titled 'month' and paste down into that column the month that data is for. Essentially you are normalizing all that data in the spreadsheet so you can import it.

If its a multiple time deal and either you or the users are going to be doing this regularly then you are going to want to build a table that you can straight import that ugly spreadsheet's data into and then either some VBA or a system of queries to extract it into your table structure.

 

[mws5872]

Is this a one time deal or do the end users want to be able to do this regularly?

If its a one-time deal I would just manually make that data importable--start a new spreadsheet and for every month bring in all the rows of data for that month and then add a new column titled 'month' and paste down into that column the month that data is for. Essentially you are normalizing all that data in the spreadsheet so you can import it.

If its a multiple time deal and either you or the users are going to be doing this regularly then you are going to want to build a table that you can straight import that ugly spreadsheet's data into and then either some VBA or a system of queries to extract it into your table structure.

Yes this will be multiple times.

 

[plog]

In that case you build a temporary table which will have the same exact structure as the spreadsheet. Each time you import data you will first truncate the data in the table, then import the new spreadsheet's data into it. From there you can build 12 queries to extract the data for one month and append it to the table that data needs to go into.

If you need more help let me know the structure of the spreadsheet and the structure of the table it needs to go into. Include all column names and datatypes.