Attemtp to Import table via query ->only empty table

[jlockley]

I have two questions: Why does this giveme only an empty table?
(I am trying to import "sfsf.db" into the larger, empty "blank.db".)


Query
ANSWER: RIV:ANSWER.DB

blank.db | last | first | email |
| changeto _last | changeto _first | changeto _email |

blank.db | Alt email | business_location | home_phone |
| changeto _email2 | changeto _company | changeto _phone |

blank.db | firstname2 | lastname2 | Business_Location2 |
| changeto _first2 | changeto _last2 | changeto _company |

blank.db | Address | City | State |
| changeto _address | changeto _city | changeto _state |

blank.db | Zip | Joined | Expires | Category |
| changeto _zip | changeto _joied | changeto _exp | changeto _status |

blank.db | Convivuim |
| changeto _conv |

sfsf.DB | First | Last | First_name2 | Last_name2 | Company | Address |
| _first | _last | _first2 | _last2 | _company | _address |

sfsf.DB | City | State | Zip | Phone | New | Email | Alt_Email |
| _city | _state | _zip | _phone | _new | _email | _email2 |

sfsf.DB | Expiration | Convivium | Joined | Status |
| _exp | _conv | _joied | _status |

EndQuery

..and
2) The above would, I think, onlyh show the fields with example elements. Could I, theoretically, put example elements in all fields of blank.db?

Working on other methods, but I'd appreciate your opinions.

Thanks.

 

[jlockley]

The above goes easily with an insert query, by the way, but I'd like to know why changeto doesn't work. Must there be files present to use this method?

 

[StuM]

Changeto only changes exsisting records.

 

[jlockley]

Oh, Duh. (blush)

It's been a while, and I think I actually figured it out. Not sure how I did it, though.


Thanks. JLL