Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: Importing dbf file

    When I am importing .dbf files into access to create a new table I want to be able to replace old tables with the same name. I can do this when importing an excel file to create a table, but when Importing a .dbf if a table exists with the same name access renames the new table. For example if I import a file named market and a table named market already exists, access creates a new table called market1. I need to be able to import the .dbf file and automatically replace the old one, so there is only one table in the database. Is this possible to do with dbf files.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Write code to check if the table exists and delete it if it does before importing the new table.

  3. #3
    Join Date
    May 2004
    Posts
    4
    where do i write the code so that it runs when I try and import the new file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •