I can't import fields in Excel having spaces to my Access table

  • Thread starter Thread starter Guest
  • Start date Start date
If you use the large white box to provide more details of your question,
it might help.
 
Care to give some details, so we know what you're talking about?

Spaces where: in the text contained in the cell, or in the field names
specified on the first row? How are you importing: through the File | Get
External Data menu option, using the TransferSpreadsheet method in VBA, or
using the TransferSpreadsheet action in a macro? Do you get any error
messages? If so, what are they? What versions of Access, Excel and, for that
matter, Windows?
 
Spaces in the field names on the first row. like Charge Amount
I want to import it in my table having charge_amt field using the
Select...Into statement...Is there any way I can import it without removing
the spaces.
thanks.
 
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

Error while import Excel file to Access 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to put single space in field? 2
Import Excel comments to field in Access 1
Import to many to many table 7
Importing from Excel to a droplist field 1
Import memo fields from Excel spreadsheet 1
How to export table from outlook into ms access table? 0

Back
Top