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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top