Update Table

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

I have a Table - "Table1" in acess. I want to import a csv file on my hard
drive and replace "Table1".

I tried --> get external data --> import

It appends the data to the table. I wanted to completely replace the data
in the table. Does anyone know how to do this?

Thanks for your help.
 
I've never seen an import append data to an existing table.

temporarily rename your existing Table1 to something different and try it
again....
 

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Suggestion for Append 3
Import table 5
Insert Values Of External Table Into Current Data Table 0
how to lookup for a value in a table? 3
Access Command button to look up and copy data from a query to a table 0
Table missing when running an <Append Query> 1
How can I quickly change the table name in a query? 15

Back
Top