Importing lists into Access

A

Alex Buiel

I have a huge Word table that needs to be imported into Access. The main
problem is that one of the fields has lists that were created using the
Enter key, which Access would read as a new record. I thought I could work
around it by replacing the paragraph symbol with a different alpha symbol
and then put it back when it was imported. I've discovered that the problem
with that solution is that under Access search and replace, there isn't any
option to insert the ¶ formatting symbol to recreate the list.

Does anyone know of a workaround for this situation?

Thanks,
Alex
 
G

gls858

Alex said:
I have a huge Word table that needs to be imported into Access. The main
problem is that one of the fields has lists that were created using the
Enter key, which Access would read as a new record. I thought I could work
around it by replacing the paragraph symbol with a different alpha symbol
and then put it back when it was imported. I've discovered that the problem
with that solution is that under Access search and replace, there isn't any
option to insert the ¶ formatting symbol to recreate the list.

Does anyone know of a workaround for this situation?

Thanks,
Alex
Click to expand...

Just a guess here but you might try importing into Excel first
make adjustments there and then import into Access. Not a good
solution if this is an everyday thing but if it's a one off
procedure it might work for you.

gls858
 
G

gls858

gls858 said:
Just a guess here but you might try importing into Excel first
make adjustments there and then import into Access. Not a good
solution if this is an everyday thing but if it's a one off
procedure it might work for you.

gls858
Click to expand...

Instead of importing which after looking doesn't seem to be possible.
Just try cutting and pasting the word doc into Excel. It worked on a small
table don't know for sure what will happen on a "huge" table.

gls858
 
A

Alex Buiel

Thanks, it was worth a try. Unfortunately, the returns forced each list line
into a new row in Excel, which pretty much replicated my original problem
when I imported it.

Alex
 
K

KARL DEWEY

Use (Chr$(13) & Chr$(10) in the Replace function.

Replace ([YourFieldName],"OldCharacter",(Chr$(13) & Chr$(10) )
 
Top