G
Guest
For what it's worth
I was having trouble getting Access 2002(10.6501.6626) SP3 to update a table linked from Excel (same version)
I whittled down the problem to the following scenario
1. Create a new blank Access databas
2. Create a table in Design Vie
3. Add Field1 Type Yes/N
4. Save the table without creating an inde
5. Export Table1 to My Documents with type Excel 97-2002 (*.xls
6. Rename Table1 as Table1
7. Get external data->link table
8. Specify Table1.xls, indicate that it has a header, and Finis
9. Open (Linked) Table
10. Type a character (best as I can tell, any character although I haven't tried them all
On my PC (running ME) this is sufficient to make Microsoft sorry for the inconvenienc
and to make me wonder if they have truly worked out the interoperational details the
seem so fond of promoting (I apologize in advance for the miniflame but I am frustrated.)
I was having trouble getting Access 2002(10.6501.6626) SP3 to update a table linked from Excel (same version)
I whittled down the problem to the following scenario
1. Create a new blank Access databas
2. Create a table in Design Vie
3. Add Field1 Type Yes/N
4. Save the table without creating an inde
5. Export Table1 to My Documents with type Excel 97-2002 (*.xls
6. Rename Table1 as Table1
7. Get external data->link table
8. Specify Table1.xls, indicate that it has a header, and Finis
9. Open (Linked) Table
10. Type a character (best as I can tell, any character although I haven't tried them all
On my PC (running ME) this is sufficient to make Microsoft sorry for the inconvenienc
and to make me wonder if they have truly worked out the interoperational details the
seem so fond of promoting (I apologize in advance for the miniflame but I am frustrated.)