peskywinnets
Registered User.
- Local time
- Today, 02:22
- Joined
- Feb 4, 2014
- Messages
- 576
So I have a problem that I can't really figure out the best way to approach.
Background: Amazon require sellers to upload product flatfile files to modify listed products in their catalogue ...these flatfiles are quite unwieldly to use, so I want to basically I want to replicate their resulting tab delimited file with an automated export from Acceess.
This would have been easy, except Amazon have three rows at the top of their text output file, here they are in pale orange...
the top row (version), is going to be static & I can simply insert that row after exporting a text file from Accees, the bottom row will be the names of my query fields....but it's how to 'lookup' the middle row text...basically I don't want to have to export all data everytime so sometimes there'll only be a few columns & at other times more columns...so I need a way of inserting that middle row, but with some form of dynamic lookup.
So after Ive exported the file from access I need Access to open the top file, insert the row with the version number, but then insert tab delimted text that is directly related to (but not the same as), my query field names.
Any ideas?
Background: Amazon require sellers to upload product flatfile files to modify listed products in their catalogue ...these flatfiles are quite unwieldly to use, so I want to basically I want to replicate their resulting tab delimited file with an automated export from Acceess.
This would have been easy, except Amazon have three rows at the top of their text output file, here they are in pale orange...
the top row (version), is going to be static & I can simply insert that row after exporting a text file from Accees, the bottom row will be the names of my query fields....but it's how to 'lookup' the middle row text...basically I don't want to have to export all data everytime so sometimes there'll only be a few columns & at other times more columns...so I need a way of inserting that middle row, but with some form of dynamic lookup.
So after Ive exported the file from access I need Access to open the top file, insert the row with the version number, but then insert tab delimted text that is directly related to (but not the same as), my query field names.
Any ideas?