Problems Linking Excel File

J

janiak

Hello,

I am having problems linking an MS Excel 97 worksheet to an Access 97
database (Yes, 97-- please don't laugh!).

If I have the spreadsheet open when I go through the "Link Table"
wizard, everything is fine. I answer the questions in the wizard and
get the following:

Field Name 1 Field Name 2 FieldName 3
Data1 Data2 Data3
Data1 Data2 Data3
Data1 Data2 Data3
Data1 Data2 Data3

However, if the worksheet is closed, I get the following:

Field Name 1 Data2 Data3
Data1 Data1 Data2
Data3 Data2 Data3
Data1 Data2 Data1
Data1 Data2 Data3

Basically-- some of the data values become field names and data values
from different columns show up in the spreadsheet. The data changes if
I make changes to the spreadsheet.

Has anyone seen this before? I have linked hundreds of excel
spreadsheets and have never seen this before. Are you always supposed
to have a worksheet open when you link-- I have not seen this as a
requirement. Could there be something specific to this spreadsheet
that is causing the problem? I have looked over it and see nothing out
of the ordinary (there are no macros/code on the spreadsheet).

Any help would be appreciated.

Thanks!

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidation data in one row 2
Crosstab leaves Blank fields 2
Writing record from Access to multiple excel spreadheets 1
Listox 2
Merge limited data field 0
Select to reference an other record or row 1
Copying Data between Spreadsheets based on a rows value 1
Chart question 2

Top