How do I export/import tables?

[Tim L]

I want to export and import tables from my database so that I can transfer data between computers without having to copy the whole database. (Which is too large for floppy - yes some people do still use them <g>).

I have tried the "Save" option, but this does not seem to produce any output at all, whether the target table is open or not.

I have also tried "Transfer Text", but this fails with "Cannot update. Database or object is read-only.", although non of the criteria for this exist (as far as I can see).

I'm using WinXp with Office/Access XP, the database is (and needs to be) in Access 2000 format.

TIA

Tim

 

[Tim L]

I've now got the export working - I'd not included the .txt extension, which it appears is needed.

Tim

 

[jtownraven]

when i ran into this problem, i just created a new database call "transfer stuff" and imported whatever i needed to copy into my other one into that one. then i just import from that one onto the other. that way i could fit whole tables and querries without the forms and reports.

 

[Tim L]

Nice idea, but not really suited for automation or use by third parties? I can't be available to do the transfers...

Tim