Importing DBF and appending to databse


R

Royce Schnepp

I am trying to create a database program that lists for real estate. I
download the data in DBF file format currently. Here is what I am trying to
do.

I have created a master database table where the DBF files are to be
appended. However, the file names change, so when I import the new DBF files,
the names are different and queries will not work. What I do is rename the
file to the same as the temp table, import it and then append to the master.

However, the problem is that on each import it creates a new table.

I either need to completley delete the table after it has been appended or
what I dont know.

Any suggestions would be a great help.
 
Ad

Advertisements

M

Mark A. Sam

Royce,

If I understand you, you are downloading a DBF file into a certain folder
then importing its data?
If yes and the downloaded file is the same name, then link the tables rather
than importing. As long as the source file is the same name, you won't have
to mess with the imported table names. The linked name will stay the same.

God Bless,

Mark A. Sam
 
R

Royce Schnepp

So, I should try and write a VB script that copies the file, renames it to
whatever I want the table to link too. So everytime I download it, it just
appends whats in the linked to the master db i create?
 
Ad

Advertisements

M

Mark A. Sam

I don't know. I thought the problem was having to change the name of the
imported table. I didn't really know how you were downloading the file. I
wasn't addressing that. It doesn't matter what the downloaded table name
is, becuase a link doesn't need to match it. You can have a table named
[Clients] and a linked named [linkClients]. After you establish a link, you
can rename it in Access.
 

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

Top