import excel .csv into access (cells +255 chrs)

M

Miskacee

Does anyone know how I can import a .csv file into Access and have Access
consider a column a memo field so those cells with greater than 255
characters will all come across (those with more than 255 characters)? I am
using Access and Exce 2002. I've tried linking the spreadsheet which of
course doesn't work either.

Thank you very much!
 
B

Bob Barnes

It's been a LONG time since I've written an Import Specification...but I
think you can
ask for a Memo field in the Spec...

Let us know - HTH - Bob
 
M

Miskacee

Thanks for your information. I tried that before I send this request and it
didn't work but thanks anyway for answering!
 
B

Bob Barnes

In making an Import Specification (I just checked that), "Memo" is
one of the selections.

Do you understand completely how to make an Import Specification?
IF not, let me know..they've always worked for me.

HTH - Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

255+ Column CSV Import 2
Field Truncation 6
ADO help : 255 Character limit on memo field....!??!?!? 4
Exporting files from Access into Excel 1
Cannot import CSV file into ACCESS 1
Convert a csv to xls prior to import 2
Import Excel with more than 255 columns 1
Exporting Access to Excel - Characters per cell limitation 0

Top