Importing data from Excell

[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

 

[Ken Snell]

There are various ways you could approach this, all involving parsing the
data from the EXCEL cells into separate values. You'll need to clearly
identify how you'll parse the values...can you expect spaces to be between
the parts, or commas, or something?

Likely, if you can figure out how to parse the data, I would import the data
into a table in ACCESS, and then write an append query that will copy the
data from the first table into a permanent table and do the parsing as part
of the append query process.