Assistance with importing Excel into Access

J

Jackie

How do you import an Excel spreadsheet with hard returns
into an Access table and retain the hard returns?
 
T

Terry

Jackie,

This question would be better in the externaldata group.

Anyway if you save you spreadsheet as a txt file (tab
delimited is fine) and import the text file into access
the hard returns are maintained.

HTH

Terry
 

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

Booklet in Word, Merge Directory from Excel 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Integrating information from Word to Excel (not mail merge) 1
Need Help with Macro Security 1
Extract embedded excel file from word document 0
Looking for Information Word (Office 365) editing using VB.Net 1
How to have two tables on same line? 1
Excell Otpions in office environment 0

Top