|  | Update Table | | |
| | | Jeff |  |
|  Posted: Wed Sep 03, 2008 7:08 pm Post subject: Update Table |  |
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. |
| |
| | | NetworkTrade | |
| | Posted: Wed Sep 03, 2008 7:14 pm Post subject: RE: Update Table | |
I've never seen an import append data to an existing table.
temporarily rename your existing Table1 to something different and try it
again....
--
NTC
"Jeff" wrote:
| Quote: | 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. |
|
| |
| | | rickw | |
| | Posted: Wed Sep 03, 2008 7:31 pm Post subject: RE: Update Table | |
Run a "Delete" query first, then import to your table.
"Jeff" wrote:
| Quote: | 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. |
|
| |
|
|
