Connecting to a server

Hello

I want to get some data from a flat file that resides on a certain server. he server containc data in such a format:

[Name1][TAB][Email1][NEWLINE]
[Name2][TAB][Email2][NEWLINE]
[Name3][TAB][Email3][NEWLINE]
[Name4][TAB][Email4][NEWLINE]
...
...
...

I have the username and password for that server.

Can someone show me the code to

1- connect to the server
2- get a file from there
3- send a file to there
4- read the data of the file show above without getting it
5- write to the file shown above withouth getting it
6- disconnecting from the server

Thanks a lot in advance

If it's a database server, you can go to Data->Import Data->New Database Query. I'm not sure I could adequately explain the process of setting up the new database query (although I can do it, most times). Someone else would have to.

Once you've obtained the data, you can process it. The two processes are independent of each other.

Processing it, you can just use Data->Text to Columns... use the TAB as the separator, and it will automatically split them for you.

If you want it as a macro, just record this whole process.

Scott