TransferText Action

yoavchen

Registered User.
Local time
Yesterday, 22:52
Joined
Jan 31, 2005
Messages
53
Can somone explaing me in a simple words what this action do?
i tried to find it in the search and i didnt understand the meaning of this macro.
my question is: can i use this macro to export the data from the db-a tables, and then to import this data into the tables of db-2?

please help
 
The transfer text macro allows you to export data in your tables to a text file or vice versa. You can also link data in a text file to an access table.

If you wish to import tables from one db to another, why don't you just use file, get external data and import? or linking the tables would be another option.

Hay
 
because i need only the data that inside the tables. if i import, the table stracture also get inside and i dont want that, i have one data base that function as a production db and i have another one with similar tables but empty, i just want to add the data into the second db which function as a development db....
i also tried to do it with a 'TransferSpreadsheet' macro, i managed to export to excel from the production db but when i want to make the import it keep saying me that the table i want to import to does not have the field 'f1'....
the problem is that i dont have field 'f1' in the export table...so i dont know what he wants from me.

'f1' is a combo that not a field in any table... can you help me with this.?
 
It sounds like you are already half way there, this will only be a small issue with regards to importing your excel file into access. If F1 is not a required field in either of the databases my advice would be to delete this from the spreadsheet then try the import again.

In my experience problems with importing occur when data types etc do not match.

Although I am a little puzzled how this has ended up in your export spreadsheet when it is not in your table in db1??
 
i deleted it and still that what i get....

Field 'F1' doesn't exist in destanationtable 'Workers'
Microsoft Office Access was unable to complete the append operation. the destination table must contain the same fields as the table you are pasting from"


This is the wierdesr thing i ever see...i dont have that field in the table i am pasting from, so ihave no idea how to fix it....!
i cecked it a houndrad times, the tables are the same they contain both 4 fields that non of them are 'F1'!?!?!?!

help me..................................................i have no idea what to do..!
 
Invalid headers

Access tries to import a field as F1 when the headers you are importing are not valid. Check your headers to see if there are any 'dodgy' characters
(.,/ \: etc). Alternatively it also uses F1 if you have not selected 'include header row on import'

Hope this helps!

Ant

edit: Also make sure that the data you are importing starts in column A as access will try to import columns without headers as F1, F2 etc..
 
Last edited:

Users who are viewing this thread

Back
Top Bottom