uploading .csv file to access

[Neerja]

Hi all,

I am trying to upload this .csv file in the access table.

The file has 6 columns. Id, date, bank, description, debit, credit, Dem, SMP
Last two columns may or may not have value for certain rows.

Tried using Split function and then using DoCmd. But the problem is the description column can contain comma in it. So using split breaks the description column in to two and try putting 2nd part of description in debit column.

I tried using the using DoCmd.Transferspreadsheet .to upload the file but gives me error Run time error 3274.

Can anyone help please?

Neer

 

[Lister]

Hint, explor these...

DoCmd.TransferText acImportDelim

Have a go, and let us know how you get on.

 

[Neerja]

Thanks for the reply..

I did try this before and it works, but in some instances it doesnt upload all the records in the file and creates a errortable.

Neer