If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Import Excel spreadsheet
Hello,
I've been trying to import an Excel spreadsheet and I keep getting the message that there is no data in the spreadsheet. I think that's because the is a field with more than 255 characters. Is there a way to import data with fields larger than 255 characters? Thanks in advance, Ellen |
#2
|
|||
|
|||
Import Excel spreadsheet
Yes. Import the field as a Memo field in Access.
-----Original Message----- Hello, I've been trying to import an Excel spreadsheet and I keep getting the message that there is no data in the spreadsheet. I think that's because the is a field with more than 255 characters. Is there a way to import data with fields larger than 255 characters? Thanks in advance, Ellen . |
#3
|
|||
|
|||
Import Excel spreadsheet
If it doesn't work, you can still save the excel file as
a text file (.txt) and import the text file into access. You can specific how you want to import the field into access by clicking the advance button in the import wizard. -----Original Message----- Hello, I've been trying to import an Excel spreadsheet and I keep getting the message that there is no data in the spreadsheet. I think that's because the is a field with more than 255 characters. Is there a way to import data with fields larger than 255 characters? Thanks in advance, Ellen . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
when import EXCEL to ACCESS, the date format excel column title changed... | Amolin | General Discussion | 6 | June 25th, 2004 08:56 AM |
take embedded excel spreadsheet in powerpoint out and into excel | Dan Orth | Powerpoint | 3 | June 13th, 2004 03:24 AM |
excel spreadsheet from another spreadsheet | Chris | New Users | 3 | May 29th, 2004 12:01 AM |
Excel - Import External Data from Access | VLeonard | Setting up and Configuration | 1 | November 7th, 2003 05:59 PM |