tanTALK - View Single Post

HollywoodTan48 · 06-26-2006, 02:08 AM

Andy,

I'm thinking about getting brave here...

MSTan has a way to export client reports to Tab Separated Value files.

It seems as if helios uses .MDB files for client info. Any suggestions on getting from my mstan TSV files to .MDB? (Visual basic style?) I'm thinking Microsoft Access should do the trick. I'm not a visual basic expert, but I was able to load the client database file into VB and break down the fields.

I don't want to convert my entire database. Just the one's I filter out. This salon has been in business for about 10 years and has alot of dead clients that haven't been in in a while.

Right now my existing database has about 15,000 clients. I only want to convert about 3000 or so of the most current ones.

Any tips on Microsoft Access for this type of conversion?

06-26-2006, 02:08 AM	#4 (permalink)
HollywoodTan48 Join Date: Apr 12 2006 Location: Salt Lake City, Utah Posts: 28 Rep Power: 0	Re: Converting to Helios from MSTan Andy, I'm thinking about getting brave here... MSTan has a way to export client reports to Tab Separated Value files. It seems as if helios uses .MDB files for client info. Any suggestions on getting from my mstan TSV files to .MDB? (Visual basic style?) I'm thinking Microsoft Access should do the trick. I'm not a visual basic expert, but I was able to load the client database file into VB and break down the fields. I don't want to convert my entire database. Just the one's I filter out. This salon has been in business for about 10 years and has alot of dead clients that haven't been in in a while. Right now my existing database has about 15,000 clients. I only want to convert about 3000 or so of the most current ones. Any tips on Microsoft Access for this type of conversion? Last edited by HollywoodTan48; 06-26-2006 at 02:14 AM.