Excel to Access Conversion

[Cotta]

Hi All,

I have an Excel spreadsheet that has 50 columns. The columns are populated in three different ways:

1. From a main separate spreadsheet.
2. Via internal calculations.
3. Via manual input.

I want to remove this spreadsheet completely and translate this into Access format, however I need Access to update from the "Main" spreadsheet.


What is the best way to do this?

 

[Ranman256]

In access ,you may need to redesign the columns. You'd need to show what your doing. BUT,
In Access, link the excel file in as a table, (external data)
Then you'll make a series of Make table queries.
These will put the columns in the correct tables.

But we need to see the table. 50 columns seems too many.