Suppress CREATE TABLE

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Some help needed for a VBA novice.

I have a CREATE TABLE statement at the start of a program which I want to
want to use when the program is run for the first time. Subsequent runs will
then append data to the table.

Can you suggest some code which will test to see if the table exists, and if
so, ignore the CREATE TABLE statement, thus avoiding the 'Table exists' error
message.

Any help would be much appreciated.

Jim Jones
 
Jim Jones said:
Some help needed for a VBA novice.

I have a CREATE TABLE statement at the start of a program which I want to
want to use when the program is run for the first time. Subsequent runs
will
then append data to the table.

Can you suggest some code which will test to see if the table exists, and
if
so, ignore the CREATE TABLE statement, thus avoiding the 'Table exists'
error
message.

Any help would be much appreciated.

Jim Jones
Click to expand...

Take a look here:

http://www.smccall.demon.co.uk/Tables.htm#IsTable
 
Back
Top