Importing records in tables

  • Thread starter Thread starter Losing Imported Data
  • Start date Start date
L

Losing Imported Data

I have a question, I am importing data into a table, if I use a macro to
create a table then 1,000 records = 1,00 records in table. If, though, I copy
and Edit paste special, 1,000 records can = 900. Any thoughts? There are no
filters or unique record identifiers, although the imported data cells can
hold 1,500+ characters, record type is set to Memo in thse cases
 
What happens if you 'link' to the data instead? Do you see all 1,000
records?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import csv truncation 1
Transferring Large Amount of Data from Excel 2003 to Access 2003 6
Import a dbf database into existing access table? 2
Import txt file - records on multiple lines 1
Import new data and replace old data in Access table. 4
Imported data into new records 4
import related records 4

Back
Top