MySQL Forums
Forum List  »  Microsoft Access

Import
Posted by: Debjit Sanyal
Date: September 13, 2010 12:22PM

Hi All,
I need help to import data from text file.

Text file data is like this:

001Debjit30Y
002Hiya 09N

Data should be loaded like
Position 1-3 first field ie 001 and 002
position 4-9 second field ie Debjit and Hiya
position 10-11 third field ie 30 and 09
position 12-12 forth field ie Y and N

I want to use shell script to insert this record from data file.

Thanks
Debjit

Options: ReplyQuote


Subject
Views
Written By
Posted
Import
2352
September 13, 2010 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.