Suppress CREATE TABLE

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
 
S

Stuart McCall

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
 

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

Deleting Tables 4
Autonumber fields 4
Automatically generate a "create table" statement 5
Create a Table with Multiple Values Listbox 0
No current record 4
Insert row, table to table - where append goes to correct record 2
Input a spreadsheet name 3
Update syntax for a remote table access 1

Top