CharlesWhiteman
Registered User.
- Local time
- Today, 08:48
- Joined
- Feb 26, 2007
- Messages
- 421
Hi all, I'm trying to get my head around one or two things, importing into access related.
In my Db I give each company an account number, IN001, for example. I have a spreadsheet of companies which I want to import. But i need to get the account number first to populate the cell in excel first.
In my Db when i manually enter a new company i have some VB code which works out what the account number should be (Letters/Numbers - Sequencial)
Dooes anyone know how i might do some code in excel to lokup my access db and do a similar thing or suggest a better way of dong it? Ta.
In my Db I give each company an account number, IN001, for example. I have a spreadsheet of companies which I want to import. But i need to get the account number first to populate the cell in excel first.
In my Db when i manually enter a new company i have some VB code which works out what the account number should be (Letters/Numbers - Sequencial)
Dooes anyone know how i might do some code in excel to lokup my access db and do a similar thing or suggest a better way of dong it? Ta.