Importing Excel Info (2000 SP-3)

Topic

New Reply

Hi,

I’m trying to create a database from some Excel information. Unfortunately, the Excel info that I want to import is set up with field labels running down the left side, instead of across the top. The column headings are for different weeks.

For example, one worksheet is four cells wide. Left to right, there’s a field label, and then field values for three different weeks.

Does anyone know any tricks for getting this info into Access and then setting it up in a table (with Week values one value of a record)?

Thanks,
Bob

Reply | Quote

Replies

Could you post a workbook with examples of
– What the Excel data looks like.
– How you want it to look in Access.

Reply | Quote

Here you go. Worksheet 1 is an example of the Excel layout, and worksheet 2 shows how I’d like the Access table laid out.

Thanks,
Bob

Reply | Quote

You don’t want a Field Category field in the result, since it doesn’t have a single value. I have attached your workbook with a macro that will populate the table in the second sheet. You can import this table into Access.

Note: I formatted column A in the second sheet as dates manually.

Reply | Quote

You don’t want a Field Category field in the result, since it doesn’t have a single value. I have attached your workbook with a macro that will populate the table in the second sheet. You can import this table into Access.

Note: I formatted column A in the second sheet as dates manually.

Reply | Quote

Here you go. Worksheet 1 is an example of the Excel layout, and worksheet 2 shows how I’d like the Access table laid out.

Thanks,
Bob

Reply | Quote

Could you post a workbook with examples of
– What the Excel data looks like.
– How you want it to look in Access.

Reply | Quote