hi all,
every company has a record and so does every customer. I have an excel sheet with columns of info. anyway i can create the records for customer and companies from this excel sheet?
thanks
Hi Saf,
You can use ODBC from Excel to update NAV.
But it might not be the best option. I would like to hear what record you talk about and what information you’re trying to update.
yes i hav an excel sheet with columns such as company name address telephone etc…
I wonder how to create new records for this (and avoid overwriting existing ones!)
saf
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
LASTNAME
FIRSTNAME
TITLE
COMPANY
COMPANY2
ADDRESS
ADDRESS2
CITY
STATE
ZIPCODE
COUNTRY
PHONE
FAX
BUSINESS
BOTHER
PRODUCTS_1
PRODUCTS_2
PRODUCTS_3
PRODUCTS_4
PRODUCTS_5
PRODUCTS_6
PRODUCTS_7
PRODUCTS_8
PRODUCTS_9
PRODUCTS_10
PRODUCTS_11
PRODUCTS_12
PRODUCTS_13
PRODUCTS_14
PRODUCTS_15
PRODUCTS_16
PRODUCTS_17
POTHER
INFLUENC
FIRSTTIM
| LASTNAME |
FIRSTNAME |
TITLE |
COMPANY |
COMPANY2 |
ADDRESS |
ADDRESS2 |
CITY |
STATE |
ZIPCODE |
COUNTRY |
PHONE |
FAX |
EMAIL |
BUSINESS |
BOTHER |
PRODUCTS_1 |
PRODUCTS_2 |
PRODUCTS_3 |
PRODUCTS_4 |
PRODUCTS_5 |
PRODUCTS_6 |
PRODUCTS_7 |
PRODUCTS_8 |
PRODUCTS_9 |
PRODUCTS_10 |
PRODUCTS_11 |
PRODUCTS_12 |
PRODUCTS_13 |
PRODUCTS_14 |
PRODUCTS_15 |
PRODUCTS_16 |
PRODUCTS_17 |
POTHER |
INFLUENC |
FIRSTTIM |
|---|
ceate a bew table and import the excel data into this table. Make sure the table contains the company name of each record. Now write a codeunit to read the data from this table and accordingly update the customer table. In the codeunit you can check the current company and the name of the company in the table. I think you to do this in all the companies you have or otherwise see if CHANGECOMPANY property can help you or not…