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
3  1799 
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jeff |
last post by:
Could someone help me out with automatically overwriting files when using a
MS Project VB macro? As you can see, I have the file saving to native
format, then to a HTML file. When it goes to save...
|
by: mike420 |
last post by:
I think everyone who used Python will agree that its syntax is
the best thing going for it. It is very readable and easy
for everyone to learn. But, Python does not a have very good
macro...
|
by: Pete |
last post by:
In Access 95/97 I used to be able to create pull down menus (File,Edit
...) from a macro. It seems there used to be some wizard for that.
However in Access 2000 it seems you have to build your...
|
by: Newbie_sw2003 |
last post by:
Where should I use them?
I am giving you my understandings. Please correct me if I am wrong:
MACRO:
e.g.:#define ref-name 99
The code is substituted by the MACRO ref-name. So no overhead....
|
by: tweak |
last post by:
I have been messing around with buffers, and
I found it peculiar that the code below will
run without a segmentation fault.
As far as I know, overwriting the allocated space
from a call to...
|
by: Steven Jones |
last post by:
I have a C program that prints out two lines as follows:
Line 1
Line 2
What I would like is for this program to sleep for one second, and then
print out two more lines, overwriting the...
|
by: skinnybloke |
last post by:
Hi - I have 3 access queries which I run via 1 macro.
Each of the queries now requires 2 parameters when they the run. The
parameters are start and end dates.
I have built the parameters...
|
by: jcf378 |
last post by:
hello--
i am having trouble figuring out how to export individual records from an Access 2002 Form into a pre-existing Excel spreadsheet, such that the exported record is merely appended to the...
|
by: Jason |
last post by:
Hi,
I need to open an existing file, seek to a position at X number of
bytes, and write out Y number of bytes overwriting any existing bytes,
but no erasing any other data. Is this possible?
...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
| |
