Update record by itself

amna77 · May 23rd, 2002, 06:36 AM

Hi, Is there anyway that you can update record in the table from excel sheet.
for example,I have One excel sheet.when ever some body is going to update that excel sheet, it should update access table as well.
Any idea how to do that?
Thanks in advance

Anne Troy · May 23rd, 2002, 07:20 AM

Sure. You need to LINK the table in Access.

File-Import from Access's menu.
No design changes can be made to the table in Access. Data can be entered either in Excel or Access.

May 23rd, 2002, 07:20 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Sure. You need to LINK the table in Access. File-Import from Access's menu. No design changes can be made to the table in Access. Data can be entered either in Excel or Access. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 06:36 AM	#1
amna77 Board Regular Join Date: May 2002 Posts: 251	Hi, Is there anyway that you can update record in the table from excel sheet. for example,I have One excel sheet.when ever some body is going to update that excel sheet, it should update access table as well. Any idea how to do that? Thanks in advance