Missing one Row

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

When I import a text file using a specification, it works
fine and gives me all 204 records, but when I automate
the import in a macro using the same file, specification,
and table to import to, I only get 203 records. It
doesn't import the first record in the text file. Anyone
have any ideas why this is happening?

Thanks!

Mike
 
If you are using TransferText in your macro, make sure that the Has Field
Names property in your Macro is set to 'No'. If this property is set to
'Yes', it will assume that the first row in the text file is a header
containing field names.
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Text Files Into Access 1
Import errors importing Text into existing table, header vs no hea 3
Unparsable Records 3
HTML Import not parsing properly when using VB or macro 1
import csv truncation 1
Type Conversion Failure importing number as text 1

Back
Top