I've worked out a way to create fully automate the process of exporting query results from MS Access to a CSV file which AwareIM can then import.
The tricky part was creating the first line of the CSV including BO.attribute info for each column of the CSV file.
If anyone is interested, let me know & I'll post details.
Tom
automate csv import from MS Access including header line
Plese post the details. What should the CSV file look like?
Assume the following:
BO.CountryName
BO.CountryCode
BO.Region
BO.Economy
Then what should the CSV file look like?
My current CSV file has CountryName, CountryCode, Region and Economy as the top cells (done in Excel) and then the data below. Where did I go wrong?
Assume the following:
BO.CountryName
BO.CountryCode
BO.Region
BO.Economy
Then what should the CSV file look like?
My current CSV file has CountryName, CountryCode, Region and Economy as the top cells (done in Excel) and then the data below. Where did I go wrong?
JTU
Spirax Sarco
Spirax Sarco
You need a header in the form
So of you add the BO's name to the fields in the header everything should work
Code: Select all
BO.Attribute1, BO.Attribute2, BO.Attribute3