Export Help Needed!

[MadMaxx]

Hello,

I have to database and I am exporting from one and putting it into another. Now I have made the tables equal so importing should word.

Now my problem is taht when I export from the db into a txt file I use , as the delimiter. When the data gets exported and I open the txt file I notice that the export has added extra delimiters. Anyone know why this is or how to get rid of it.

Thanks

 

[jeremie_ingram]

If you have blank fileds within the dataset, you will recieve consecutive delimiters.

 

[MadMaxx]

Figured out the problem. But now I want to automate it. I have automated the export of the data but when I try to import it into the other db with the a macro it say field F1 not in table. But if I do it manually throught the menu it works.

Any ideas?

 

[Pat Hartman]

Use the option to include headers in the first row. You don't have to go through the export/import steps, you can use TransferDatabase to transfer a table directly to another db if that would simplify your process.