Importing data to new database

  • Thread starter Thread starter Yee Tien
  • Start date Start date
Y

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
 
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.
 
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!
 
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.
 
1. You (usually) get what you pay for.

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

I've been playing with the tools.

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

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
 
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.
 
Black Moshannon got back to me. Only email, fax, and phone
order.

Hmm... really need to reconsider now...
 
Back
Top