If I analze a table in exce and make changes in excel will the sh.

S

Seering

I tried to add a row to a table from access that I analyzed in excel, when I
went back to acces the row wasn't there, is there anyway I can make changes
while analyzing tables from access in excel.
 
J

John Nurick

Hi Seering,

If you used the "Analyze it with Microsoft Excel" menu command, the
answer is no. This command exports the data in the table into a new,
freestanding Excel workbook with no link to the database.

It's possible to update an Access table from Excel but it's not easy to
create a reliable two-way link. In general it's much simpler to edit the
data in Access before exporting it to Excel.
 
Top