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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access #Error & Excel Pivot 0
Unable to Change Table Design 5
Importing from excel 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Access 2003 Table Analyzer 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Multiple sheets in an excel file 1

Back
Top