Newbie..

[ange]

Hi! I just recently graduated from school, so I'm a little shaky with the language if you guys could bare with me
I have been coding in embedded vb for the past 3 months, so I'm familiar with ADO. What I need to do is transfer a large file into a database. Any suggestions on how?
ange

 

[Tim1]

Hi Ange,

A couple of things:

1. What format is the current file in? eg. text, comma delimited etc.
2. What database are you going to be using?

Tim

 

[ange]

Hi Tim,

1. The format is fixed length fields, no comma delimited or anything.
2. The database is an Access Database called Config.mdb.

ange

 

[Tim1]

Hiya,

You have a fairly simple task, Access comes with an excellent import routine. Basically, all you need to do is go to the table option, then select new.

You then need to change the file type (at the bottom) to a text file, and find the file that you want to import. Access will then guide you through the rest, allowing you to specify where fields begin / end, specify file names etc. for your final table.

If you get stuck, there is an Access forum on here, where people who use the database all day look, so if you get problems processing your data, place any further questions in there.

Have fun!!

Tim

 

[ange]

I have done that in the past, but the difference is that I'm not working in Access, but something called VisData, which works with Access datbases, but is not Access, if that makes any sense. The application can open my database and I can work fairly easily wiht them, but my boss just bought vb 6 in order to programmically add the data. I'm not sure if this is because I cannot do that in VisData or not. So, basically, I was wondering if there was a way to programmically import the data into the tables I have.. if that makes sense.
ange