Resetting TableDefs in a loop - Urgent

[Guest]

Hi,

Thanks in Advance. Need urgent help on this on. Have a loop that imports a
table from excel then looks at field names and appends to a table.

Problem is that field names don't refresh and keep the previous names how do
I reset field names?

Sample code is:-

loop starts here

Delete table test1 here

Import excel file (Test1) here

need help here
Tabledefs not resetting

For Each fld In dbs.TableDefs(Test1).Fields

do work here
add details to new file
next loop

 

[Duane Hookom]

Since we are only seeing pseudo code, I can only suggest that you use a line
like
CurrentDb.TableDefs.Refresh

 

[Guest]

Just the ticket.

Thanks very much.

Working perfectly.