B
Bhagya
Hi,
We have developed an Access database. We now want to
export the data that we have been collecting in Excel.
However we are running into problems.
For instance we have a whole new form for customer
address, with fields for zip code, street address etc.
But the address data is collected in one field in Excel.
Is there a way to separate the data within the excel field
and then import that into different fields in a access
table.
Bhagya
We have developed an Access database. We now want to
export the data that we have been collecting in Excel.
However we are running into problems.
For instance we have a whole new form for customer
address, with fields for zip code, street address etc.
But the address data is collected in one field in Excel.
Is there a way to separate the data within the excel field
and then import that into different fields in a access
table.
Bhagya