Problem in Linking Excel files in Access

[karthik28]

I tried linking an excel spreadsheet to an access database. It shows me a window with the data but the header row in missing. However, when I open the excel file, save it without making any changes and try linking it again, it works fine.

Please suggest a solution so that I dont have keep saving the excel file before linking it.

Thanks

KS

[Curben]

I tried linking an excel spreadsheet to an access database. It shows me a window with the data but the header row in missing. However, when I open the excel file, save it without making any changes and try linking it again, it works fine.

Please suggest a solution so that I dont have keep saving the excel file before linking it.

Thanks

KS

Is the Excel file saved on the local machine your working on?
Sometimes an excel file can be corrupted in a way that doesnt affect the files operation but will effect its interaction with other programs. If the files are based on one master file, you may need to correct the excil file that used as a template so all others will be correct.

Otherwise if the file is generated by another programs output, the program may be putting in garbage data or characters causing the same problem.

If none of this is accurate to your issue, then please also let us know your version of access

[karthik28]

Is the Excel file saved on the local machine your working on?
Sometimes an excel file can be corrupted in a way that doesnt affect the files operation but will effect its interaction with other programs. If the files are based on one master file, you may need to correct the excil file that used as a template so all others will be correct.

Otherwise if the file is generated by another programs output, the program may be putting in garbage data or characters causing the same problem.

If none of this is accurate to your issue, then please also let us know your version of access

I am getting data from an AS 400 mainframe into an excel file and trying to link it in access.

The access I am using in 2003. The same linking process is working fine on another computer ...

Please suggest how can I proceed to correct the problem.

[Curben]

I am getting data from an AS 400 mainframe into an excel file and trying to link it in access.

The access I am using in 2003. The same linking process is working fine on another computer ...

Please suggest how can I proceed to correct the problem.

do both workstations have the same versions of access and excel?

[karthik28]

do both workstations have the same versions of access and excel?

Yes, they do .. Is this an unusual problem?

[Curben]

Yes, they do .. Is this an unusual problem?

Well, it certainly shouldnt be happening :)

So as I understand:
2 PCs
each with a version of access and excel, both have the same versions.
the output file is from a mainframe and both PCs access the same copy of the output file.
The possible options I can think of are this:[list][list=a][*]Access Settings that are different[*]DB settings that are different[*]Excel settings that are different[*]PC settings that are different

If you open and close the file w/o making changes does it prompt for save, and if so what exactly is the dialogue in the notice?
Are both DBs running as the same version? i.e. both could be access 2003, but one DB could be in a 2000 format.
As a small test if you can, make a back up the DBs and place the backups on the other machines. This way we can determine whether its a Database based issue, or a machine based issue.