| Author |
RE: Importing Data Into Existing Tables Without Emptying Them Firs
|
|
| Amy E. Baggott 2005-09-27, 8:25 pm |
| Will the link go away each time the other database replaces the file?
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
"Klatuu" wrote:
[color=darkred]
> Yes, you can link to a csv file and use it like a table. You will then have
> to create either queries or VBA code to append the records you want.
>
> "Amy E. Baggott" wrote:
>
| |
| Klatuu 2005-09-27, 8:25 pm |
| No, you need to establish the link, do your processing, the destroy the link.
Use the DeleteObject method
"Amy E. Baggott" wrote:
[color=darkred]
> Will the link go away each time the other database replaces the file?
> --
> Amy E. Baggott
>
> "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
>
>
> "Klatuu" wrote:
>
| |
| Amy E. Baggott 2005-09-27, 8:25 pm |
| How do I establish the link using code?
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
"Klatuu" wrote:
[color=darkred]
> No, you need to establish the link, do your processing, the destroy the link.
> Use the DeleteObject method
>
> "Amy E. Baggott" wrote:
>
| |
| Klatuu 2005-09-27, 8:25 pm |
| Use the TransferDatabase method. Look it up in VB Editor Help. You will
find all the specifics there. Good Luck.
"Amy E. Baggott" wrote:
[color=darkred]
> How do I establish the link using code?
> --
> Amy E. Baggott
>
> "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
>
>
> "Klatuu" wrote:
>
| |
| Amy E. Baggott 2005-09-27, 8:25 pm |
| TransferDatabase does not appear to work with a csv file, or at least does
not list that among the options. The only method that does is TransferText.
Is that what I should be using?
--
Amy E. Baggott
"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
"Klatuu" wrote:
[color=darkred]
> Use the TransferDatabase method. Look it up in VB Editor Help. You will
> find all the specifics there. Good Luck.
>
> "Amy E. Baggott" wrote:
>
| |
| Klatuu 2005-09-27, 8:25 pm |
| D'oh!
Too much going on in my head today. Sorry, you are correct. Also, you
can't link to a text file, you have to import it. Every thing else should
work the same, so.
Import the text file to a temporary table. Append to you permanent table,
then delete the temporary table.
My apologies for leading you astray.
"Amy E. Baggott" wrote:
[color=darkred]
> TransferDatabase does not appear to work with a csv file, or at least does
> not list that among the options. The only method that does is TransferText.
> Is that what I should be using?
> --
> Amy E. Baggott
>
> "I''m going crazy and I''m taking all of you with me!" -- Linda Grayson
>
>
> "Klatuu" wrote:
>
|
|
|
|