Importing data to new database

[Yee Tien]

Hi,

I'm trying to import data to a new database.

So I'll need to import tables from existing database,
write and run insert query for each table, and delete
imported tables.

Is this a correct way of doing so? Any easier method?

Thank you.

Regards,
Yee Tien

 

[Joe Fallon]

Not enough detail to give you a good answer.
You need to explain what you have and what you are trying to do.

If you just want to create a new mdb file and import objects from an old mdb
file you can just do that and be done.

 

[Yee Tien]

Hi Joe,

Thanks for reply

The existing database is having same table names with
spaces in between and have some column names using
keywords like "Name".

I'm thinking of creating a new database to get rid of the
name spaces and keywords.

I need to create a new database because existing one is
running live. So I'll have to do the importing of live
data to the new datatabse during a weekend.

Do you think it's neccessary for all these? Is Access able
to process those spaces and keywords correctly? We are
having some conflicts here and there and wonder if it's
because of them causing the problem.

Hope that the info is enough.

Thanks again!

 

[Joe Fallon]

Much better. <g>

Yes - those are serious design flaws and should be corrected.

3rd party tools like Find and Replace can operate on a copy of the current
mdb.
(Always use a copy in case something goes horribly wrong.)
They are much better than the built-in name changing feature in Access.

If you follow your original plan to migrate stuff then there will be a lot
more work involved.
(I would buy the tool, fix the problems and bdone with it. Plus you have the
tool for future use.)
You would have to bring in the tables, re-name everything, re-write queries,
fix forms, reports and code.
A major task depending on the size of the mdb.

 

[Yee Tien]

Hi Joe,

Thanks for the suggestion!

Wow... seems like there're quite a few Find and Replace
tools around. And 1 is even free
(http://www3.bc.sympatico.ca/starthere/findandreplace/).
You got any recommendations?

Regards,
Yee Tien

 

[Joe Fallon]

1. You (usually) get what you pay for.

2. I used Black Moshanon's tool years ago and found it did a great job.

 

[Yee Tien]

Hi Joe,

I've been playing with the tools.

Black Moshanon's tool works the best and it costs the most
also

I'm thinking of getting it. However, it requires me to
send credit card info through email which I don't think
it's safe. Do you remember how did you purchase it last
time?

Also, do you know of other tools that do importing easily
as well?

Thank you

Regards,
Yee Tien

 

[Joe Fallon]

I agree that credit card info in an email is a bad idea.
Don't they have a secure website or PayPal?

I bought it 7 years ago so I don't recall how it was done.

 

[Yee Tien]

Black Moshannon got back to me. Only email, fax, and phone
order.

Hmm... really need to reconsider now...