import text files into access 2003

G

geek

Hi,
i need some help in transferring the data in the Text file to the tables
in access 2003. below is a sample of how the text file looks like.


DATE :11/08/06
BUYER : M00000 S.X.X

ORDER NO. :(Sxxx-SP-000/00) LOCA

TERMS/CURRENCY : 15th of next month / S$ or US$ or Yen
PAYMENT : 15th of next month
PACKING : CARTON CASE
PORT/DESTINATION: SINGAPORE
SHIPMENT : 4:BY SEA & ROAD
APPROVED BY : Ang xx
REMARK :

ITEM PARTS CODE MODEL NO. Q'TY DESCRIPTION PRICE
1 8500000017000 see desc 5 GRILLE COVER I-CAPX-0002 @.
0.30

please help me on the transfer of these types of data into a table
in access 2003.

thanks in advance!!~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import text files into access 2003 0
importing text files into access 2003 3
Import a file using a field on a form 0
Access 2003 -- Importing Text File -- Nulls 1
Problems with importing a text file in Access 2007 7
Importing a text (.txt) file into a 2003 database 0
problems importing a Paradox file into Access 2003 4
Import mutiple name text files into Access 2003 1

Top