Import a new table under a Button

[Guest]

How would I be able to program a button that would Import a new table
everytime. I do not want to import into a existing table. I want to import
into a new table that does not exist in the database. is this even possible?
I have a crazy spreadsheet that I converted from PDF and it will import once
but when I try to import into the existing table it will not work.


Thanks

 

[Guest]

Why ??

You are going to end up with a whole load of tables that are just taking up
disk space. Why not just append any new data to an existing table.

 

[pietlinden]

How would I be able to program a button that would Import a new table
everytime. I do not want to import into a existing table. I want to import
into a new table that does not exist in the database. is this even possible?
I have a crazy spreadsheet that I converted from PDF and it will import once
but when I try to import into the existing table it will not work.

Thanks

Define "will not work" - do you get a primary key violation or
something? Try creating a holding table for the data and leave the
constraints out (not null/required, in some range, etc). Then try
it. You can then use queries to append the cleaned data where you
want it to go. Otherwise, I'd agree that they files should all go
into the same table. Otherwise get real comfortable with union
queries...

 

[Guest]

Hi

I have just posted one method (that I think may work for you - if you can
get the data into a db) on the general question section. Have look -

Good luck

 

[Guest]

Thanks Wayne I-M. You are right I would have a lot of tables but I would
Delete them Every Time I Import my new tables.

The error message I get is The info will not import.