flatfile-db ---> access-db problem. NEED HELP!

[allert]

Trying to write a script that converts a (used cars) flat-file-database to an Access-database, I keep running into the following problem:

The original, flat-file-db, looks like this:
id|mark|type|field4|field5|field6|PRICE|field8 etc.
Using the FileSystemObject, the script reads the lines and, using MyArray = Split(strLine,"|&quot, puts the values in an array. After that, the script assigns the values to their respective access-db-fields: rst("Mark&quot = MyArray(1) etc. All fields go well, except for the PRICE field. This is the only field that is declared as being numeric in Access, but I didn't think that had to be a problem. As it turns out, it is. rst("Price&quot = MyArray(7) doesn't work, whereas manually assigning a 'string' type value to it does: rst("Price&quot = "17950" works fine. But that's useless, as you'll all understand.

My question: how on earth can I solve this problem? It's really important, because otherwise I will have to manually insert hundreds of cars in the Access-db ;-)

 

[NickBulka]

Have you tried converting to numeric for that field? Assuming that the field is a long integer, the syntax would be
rst("Price&quot = CLng(myarray(7))

 

[MichaelRed]

Allert,

I almost ALWAYS do import of 'stuff' as text. This does not impose conditions on the 'stuff' I'm trying to get. After it is loaded into MS Access, you can do any conversion necessary. Often, even changing field types from text to numeric can be accomplished within an existing table - provided you have reviewed the data and 'fixed' any problems. It is relatively easy to groom the imported data via queries which check the data via criteria like "IsNumeric" ...

 

[onetomany]

Why dont you just use the import features that are included in access. They allow you to assign data types at the time of import using a wizard.

Unless theres something I missed in your post that would prevent you from doing this.