Append Data MVFs

[raychow22]

Hi Forum,



I know having MVFs are a bad idea especially for SQL; however, they are super useful for me and I want to be able to continue to use them. With that said, the MVFs does not allow me to append my tables. I want to easily append my "Table" data (records) together without having to copy and paste them in each time. Is there a good way to do this?

Thanks,

[CJ_London]

not if you are using mvf's, tho' should work if you exclude them from the copy/paste - i.e. have then all at the far right of the table datasheet. Or create a simple select query which excludes them and paste into that instead.

Otherwise, don't use copy/paste use something like transfertext or transferspreadsheet in vba or the import facility - but again, avoiding the mvf's