D
David Saywell
Hi,
I have an Excel Spreadsheet containing budget data that I need to import
into my access database.
The Excel "Budget" table contains the following fields:
GLAccountId
JulyBudget
AugustBudget
SeptemberBudget
OctoberBudget
etc.
I want to store the data in Access with the following fields:
GLAccountId
Month
Budget
Effectively creating twelve records for each GLAccount (one per month).
How can I use Access to automate this process?
Thanks,
David
I have an Excel Spreadsheet containing budget data that I need to import
into my access database.
The Excel "Budget" table contains the following fields:
GLAccountId
JulyBudget
AugustBudget
SeptemberBudget
OctoberBudget
etc.
I want to store the data in Access with the following fields:
GLAccountId
Month
Budget
Effectively creating twelve records for each GLAccount (one per month).
How can I use Access to automate this process?
Thanks,
David