By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Macro: TextTransfer and overwriting

P: n/a
In a macro I use TextTransfer to import a textfile with an
importspecification. Is it possible to make sure the old imported table gets
overwritten by this action? Because now, the import doesn't take place as
the old file is still there. And I can't find an action that first deletes
the old table.
Thanks in advance,
john
Aug 26 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
rather than deleting and creating the table each time, suggest you run a
Delete query to delete all records from the table, then run the TransferText
action to import the new data to the existing table.

hth
"john" <jo**@test.comwrote in message
news:bL********************@casema.nl...
In a macro I use TextTransfer to import a textfile with an
importspecification. Is it possible to make sure the old imported table
gets
overwritten by this action? Because now, the import doesn't take place as
the old file is still there. And I can't find an action that first deletes
the old table.
Thanks in advance,
john


Aug 26 '06 #2

P: n/a
Ah, now I see what it does, it adds the records, in stead of replacing the
whole table.
Thanks a lot!
john
"tina" <no****@address.comschreef in bericht
news:if********************@bgtnsc04-news.ops.worldnet.att.net...
rather than deleting and creating the table each time, suggest you run a
Delete query to delete all records from the table, then run the
TransferText
action to import the new data to the existing table.

hth
"john" <jo**@test.comwrote in message
news:bL********************@casema.nl...
>In a macro I use TextTransfer to import a textfile with an
importspecification. Is it possible to make sure the old imported table
gets
>overwritten by this action? Because now, the import doesn't take place as
the old file is still there. And I can't find an action that first
deletes
the old table.
Thanks in advance,
john



Aug 26 '06 #3

P: n/a
you're welcome :)
"john" <jo**@test.comwrote in message
news:Wu******************************@casema.nl...
Ah, now I see what it does, it adds the records, in stead of replacing the
whole table.
Thanks a lot!
john
"tina" <no****@address.comschreef in bericht
news:if********************@bgtnsc04-news.ops.worldnet.att.net...
rather than deleting and creating the table each time, suggest you run a
Delete query to delete all records from the table, then run the
TransferText
action to import the new data to the existing table.

hth
"john" <jo**@test.comwrote in message
news:bL********************@casema.nl...
In a macro I use TextTransfer to import a textfile with an
importspecification. Is it possible to make sure the old imported table
gets
overwritten by this action? Because now, the import doesn't take place
as
the old file is still there. And I can't find an action that first
deletes
the old table.
Thanks in advance,
john



Aug 26 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.