| Author |
Text too large to be in a field
|
|
| bmoos1@yahoo.com 2005-08-26, 3:24 am |
| I have some information about a particular company that I need to
access when I'm in a form. In the table the data won't import from
excel because it's too large (over 255). I would really like that
information to show up on the form when I click a button. How can I do
this? Any help. I'm a beginner.
Grammie
| |
| Br@dley 2005-08-26, 3:24 am |
| bmoos1@yahoo.com wrote:
> I have some information about a particular company that I need to
> access when I'm in a form. In the table the data won't import from
> excel because it's too large (over 255). I would really like that
> information to show up on the form when I click a button. How can I
> do this? Any help. I'm a beginner.
>
> Grammie
Try a Memo field type.....
--
regards,
Bradley
A Christian Response
http://www.pastornet.net.au/response
| |
| Barbara Duncan 2005-08-26, 8:24 pm |
|
I tried that and it wouldn't export into Access because too much text
for the field. The text is well over 1000 characters. Any other
suggestions?
Grammie
*** Sent via Developersdex http://www.droptable.com ***
| |
| Ronald Roberts 2005-08-27, 3:24 am |
| bmoos1@yahoo.com wrote:
> I have some information about a particular company that I need to
> access when I'm in a form. In the table the data won't import from
> excel because it's too large (over 255). I would really like that
> information to show up on the form when I click a button. How can I do
> this? Any help. I'm a beginner.
>
> Grammie
>
Try saving your excell file as a text, tab-delimited file.
Then Import the new file into Access. Try importing it into a new
table, not an existing table.
Ron
|
|
|
|