import from excel, format and put in an Access table

[dorjee]

Hi,
i would like to import data from a spreadsheet to an Access table that is created then. The trick is that the data in excel must be formatted(it is originally contained in a single cell in each row and in text; this data should be thus formatted from one cell into several field data, for each row). Hope this is clear..
any help appreciated!

 

[steveouthwaite]

Give us a clue...

An example of the kind of text in your spreadsheet would help

SteveO

 

[simeybt]

you could use the text that is continued in one column and parse it using excel functions into several columns of data.
give us and example of your text

Simon

 

[PHV]

You may consider to take a look at the TextToColumns method of the Range object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884