Search results

Hi Chris. Thanks for the reply - and how's the weather in the South Hem - we have Snow in Scotland! I have thought this through in various formats, but I'm hampered by the way the CSV file is presented to me (horizontally), and the way I want to present it (vertically). I am doing this...

Files are attached. The table I'm importing into is in DB1, and the two RX numbered files contain the orders I'm importing, including the blank columns. Adam

For a moment I thought I had a solution. I set up an Import Specification which solved the problem with the blank columns, and imported without error warnings. However, the problem with the Import Specification is that although the products I'm importing have the same name in each file, they...

The search though the "Pat Hartman" archives has provided the perfect (and deliciously simple) solution. Thanks for the help - would not have found it otherwise. Now all I need to do is sort out the issue with importing blank columns see...

Thanks guys. Will search further. Adam.

Other people use the csv files, so I have no control of how they look, or when they are deleted. There may also be files in the same folder which I do not want to import. hence I want to give the user the option to browse for the file they need to import.. These things are never simple!

Thanks, but I have tried this. I need to add "true", as I need to bring in the fieldnames so I can match the correctl orders with the correct products. This causes the problems on the blank columns. I can't find anything in the help on transfertext which explains what to do about blank...

I have had a good search around the forum, but can't find a solution to this one either. Any help, or links to a solution would be appreciated. I'm sure this must have been covered before somewhere. The csv file with my daily orders (which I am trying to import using the transfertext in a...

I have had a good search around the forum, but can't find a solution to this one. Any help, or links to a solution would be appreciated. I am using code to import an Excel CSV file into a pre-formatted table. My problem is the csv file is automatically generated each day, and has varying...