Here in as much detail as possible is everything I am doing to try an import my budget files.

I have two data directories involved. One contains my budget information with some new accounts as well. The other contains my acutal GL data for this year and last. I want to import the new accounts and the budget into the current year gl.

Here are the the structures of my import and export files:

Export of Budget Infomation and New Accounts

File Formate: Excel
File Name: V:\my documents\ken\budget\03_04\band budget.xls

OPTIONS:
Header Included? Yes
Overwrite Existing File? Yes

Separator? None

Field Selections:
Account Code
Department Code
Description
Period 1 - Budget
Period 2 - Budget
Period 3 - Budget
Period 4 - Budget
Period 5 - Budget
Period 6 - Budget
Period 7 - Budget
Period 8 - Budget
Period 9 - Budget
Period 10 - Budget
Period 11 - Budget
Period 12 - Budget
Account Type
Consolidation Option
Account Status

Import of Budget Infomation and New Accounts

File Format: Excel (Version 2.1-5.0)
File Name: V:\my documents\ken\budget\03_04\band budget.xls

OPTIONS
Header Include? Yes
Overwrite Records? Yes
Add New Records? Yes
Validate? Yes
Separator? None
Use 4 Diget Years? No
Use Extended Character set?

Import Field Selection
Account Code
Department Code
Description
Period 1 - Budget
Period 2 - Budget
Period 3 - Budget
Period 4 - Budget
Period 5 - Budget
Period 6 - Budget
Period 7 - Budget
Period 8 - Budget
Period 9 - Budget
Period 10 - Budget
Period 11 - Budget
Period 12 - Budget
Account Type
Consolidation Option
Account Status

Field Defaults:
None Selected

Import Figures with NET CHANGES
REPLACE figures with imported values

I then get an error message that reads:

"The file layout for V:\my documents\ken\budget\03_04\band budget.xls is incorrect. Import is Aborted"

I have also attempted the import using the CSV delimited file type for the export and import processes. I receive different error messages when doing this as follows:

"Corrupt data has been found in the first line of the file. If you have a header line please delete it before importing."

I recieve this message whether or not I export/import with a header option selected.

When I click OK after the above error message I get another error messages that says:

"Invalid data for field called '0'of record Account Type"

"Imports cancelled. No records were imported."

I know this process works as i had no problem importing back into my budget database after adjusting the budgets in excel, But the import as above does not work in either the new gl database or the budget database.

HELP!!!!!

Ken