parse data into flat file structure 
Author Message
 parse data into flat file structure

Does anyone have a series of qry's or proceedure that will take a field in
multiple records and place in multiple fields in one record...

example:

3 invoice numbers in 3 invoice records placed into
hist1 field, hist2 field, hust3 field in one record.

thanx



Wed, 05 Jan 2005 05:28:25 GMT  
 parse data into flat file structure
Maybe a cross-tab query?


Quote:
> Does anyone have a series of qry's or proceedure that will take a field in
> multiple records and place in multiple fields in one record...

> example:

> 3 invoice numbers in 3 invoice records placed into
> hist1 field, hist2 field, hust3 field in one record.

> thanx



Sun, 09 Jan 2005 23:58:18 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Need Help Parsing Flat File!!

2. Parsing Flat Files

3. Import data from flat ascii file

4. Help with SQL and flat file data

5. Challenge!Need 2 load data into GUI application using flat file + keystrokes

6. writing form data to a flat file.

7. Loading data from a flat, delimited file

8. How to parse data from a HTML file to VBA

9. Parsing different structures through a function

10. Parsing data from text and html files

11. parsing data in a text file

12. data structure of gif/jpg file?

 

 
Powered by phpBB® Forum Software