insert a deleted record back in access table at the same location

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

Hi All, I am pretty new with access database. I deleted a record(entire row)
from one of my tables in access. the table is not linked to any other
tables.. Is there a way I can insert that record back in? I have that record
in excel file, and i want to insert that record at the exact same location,
for eg, insert it as 10th record .. there are about 100 records in this table.

Thanks in advance
 
From a practical standpoint it makes absolutely no difference
where the record is located within your table. A table is just
a set of records in no particular order. If you want to see the
records in a particular order, you use a query and you sort
the data by one (or more) of the fields.
 
Hi All, I am pretty new with access database. I deleted a record(entire row)
from one of my tables in access. the table is not linked to any other
tables.. Is there a way I can insert that record back in? I have that record
in excel file, and i want to insert that record at the exact same location,
for eg, insert it as 10th record .. there are about 100 records in this table.

Thanks in advance
Click to expand...

Yes, you can insert it back into the table. No it won't go into the
same location. Order in tables doesn't matter, you should use a query
to get your records into the order you want.

To insert it in, you can import the data from your excel file. In
Access 2000/2003, go to File, Get External Data, Import and follow
through the wizard. In Access 2007, go to the External Data tab of the
Ribbon and click Excel, follow through the wizard.

Keven Denen
 
Back
Top