Extracting data from Access

[mike99]

We have to extract data from an Access Table. It is customer address information that is in one column in Access with a special character that looks like a "square box" separating the address lines. How do we get the info out of access onto individual lines or columns? We have tried "parse" in Excell but it does not recognize the "square box" character.

Mike99

 

[sinyce]

Dont know if this will help, but I've seen this when Import a text file into Access. From what I noticed its always present where a TAB separates the fields.

My guess - thats how it got into the Access database in the first place - from an imported file.

Hope this helps

 

[thornmastr]

You need to be able to identify that character. There are numerous string functions which will allow you to parse out sub strings but you do need to identify the delimiter a bit more realistically than a square box thingy.

As a point of reference you really do not want to concatanate multiple strings into one colimn of a table. There is a rather big distinction between a properly defined table and a spread sheet. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[sko]

You should be able to use 'Text to Columns' in excel.
To test your problem, I copied and pasted some data into an Access field from a tabbed column in Word. The result in Access was a data string with boxes representing the tabs.

I then exported to excel and parsed the data with no problem.