Automatic Data fill in Query

[Djbell]

Hi All

I have a linked table that links to a CSV file, which imports the data in the following structure!

Item No Name Price Quantity
1111 ItemA 20 20
21 23
25 26
2222 ItemB 11 31
10 36
333 ItemC 5 16
3 11


What I would like is to create a query so that it does the folowing with the information.

Item No Name Price Quantity
1111 ItemA 20 20
1111 ItemA 21 23
1111 ItemA 25 26
2222 ItemB 11 31
2222 ItemB 10 36
3333 ItemC 5 16
3333 ItemC 3 11

Is this possible?

Regards

Djbell

 

[AlexCuse]

I would discuss with the source of the .csv file how you can get the file delivered in the format you need.

This may be possible through VBA (it is for normal .xls files), but I'm not sure it'd be worth the effort when it's a somewhat minor change on the part of whoever sends the spreadsheet.

Good Luck!

Alex

A wise man once said
"The only thing normal about database guys is their tables".

 

[Djbell]

Hi

This is an export out of a databases system, its a report that gets exported to a CSV file, unfortuantly this is a Bespoke report and cannot be changed.

Regards

Douglas Bell

 

[Remou]

Please do not duplicate posts.
Automatic Query
thread701-1301848

 

[Djbell]

Yeah

Sorry for the duplicate post but wasnt sure wich one the topic belonged in.

Regards

Douglas Bell