how do I check if a field exists and create it if not?

  • Thread starter Andy Ralph - Hastings
  • Start date
A

Andy Ralph - Hastings

Using Access 2003, I am importing from Excel 2003. We use various templates
which get up-issued as new requirements are identified. I need to import the
data from any issue of template. Older template formats don't have all the
fields of the latest.
when I use DoCmd.TransferSpreadsheet acImport, 8, "tblQuoteDataTemp",
tbFile, True, "RFQ!u1:ad2" to import a range from the spreadsheet tbFile, old
template versions have blank cells where the latest has Field names.
I get a table with Field names F1, F2 etc.
I want to be able to specify default field names for the blanks or use a
query to transfer the data to another table where I can set default field
names.
 

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

Matching literal text "???" in Word 2010 field code IF statement 2
Cannot repeat import table from Excel 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Can I export from Access to Excel using field names not captions? 0
export vba not working 0
Publisher is filling blank lines with data 2
How do I install Microsoft Equation 3.0 back to Office 365? 0
How do I combine IF(ISNUMBER(SEARCH and VLOOKUP( formulas 0

Top