Importing formats from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel sheet which contains some data that is formatted in bold and
red. Is there anyway I can retain the formatiing (to differentate between
other data) when I import it into Access.

Can I differentate between the two formats when I run a query?

Thank you
 
Kim,

No, whatever information is conveyed by the format differences, you have
to put in a separate column in Excel and import as a separate field.

Nikos
 
Thank you for clearing that up!

Nikos Yannacopoulos said:
Kim,

No, whatever information is conveyed by the format differences, you have
to put in a separate column in Excel and import as a separate field.

Nikos
Click to expand...
 
You must log in or register to reply here.

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

Forms used to run query 6
Multi user database - Problems! 1
Docmd.TransferSpreadsheet imports text fields in wrong format 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import data from excel into access tables 2
Formatting Number during Import or via Update Query 1
Formatting issue with imported telephone number! 2
Import data from Access to Excel containing VB code 3

Back
Top