J
June Macleod
Has anyone here used the Office Spreadsheet Tool in MS Access 2003?
I can add a spreadsheet tool to a Page and have it display records from one
of the tables but when I update the values on the spreadsheet the table
behind it does not pick up these values.
I have tried connecting the data using both the "Data Member in Workbook
Data Source" option and the "Sheet Data Source" (using Jet 4 and pointing to
my database) option but neither let me update the underlying table. I have
tried the help files but they send you round in circles without ever
actually telling you anything.
If someone could give me some pointers it would be much appreciated.
June
I can add a spreadsheet tool to a Page and have it display records from one
of the tables but when I update the values on the spreadsheet the table
behind it does not pick up these values.
I have tried connecting the data using both the "Data Member in Workbook
Data Source" option and the "Sheet Data Source" (using Jet 4 and pointing to
my database) option but neither let me update the underlying table. I have
tried the help files but they send you round in circles without ever
actually telling you anything.
If someone could give me some pointers it would be much appreciated.
June