automate csv import from MS Access including header line

tford · Post by **tford** » Wed Mar 28, 2007 4:05 pm

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

avatar69 · Post by **avatar69** » Thu Mar 29, 2007 8:04 am

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?

Hubertus · Post by **Hubertus** » Thu Mar 29, 2007 8:20 am

You need a header in the form

Code: Select all

BO.Attribute1, BO.Attribute2, BO.Attribute3

So of you add the BO's name to the fields in the header everything should work

avatar69 · Post by **avatar69** » Thu Mar 29, 2007 8:31 am

Thank you!!! You are a GENIOUS! I've been going around the loop on this like crazy, and couldnt figure out what went wrong.... Many thanks again.

pixerp · Post by **pixerp** » Thu Mar 29, 2007 3:29 pm

The way I found to be easy is :

. create the BO with the attributes
. enter some information
. export the csv file
. open the csv file in OpenOffice Calc - straightforward (not in Excel)
. copy and paste your data
. import your csv file.

Just my little experience.