Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Transfer Text - Character missing from input data

Posted on 2008-11-17
Medium Priority
Last Modified: 2013-11-27
If I manually import a .csv file in an access table, I have no problem.  However I am now trying to use Transfer Text in a macro to import the data.  When I do the import using Transfer Text, the first character of the third column of data is missing in the table.  For example, if a cell in the the third field in the.csv contains K11, the table field contains 11.(Note - the fomat of the data in this field is a letter followed by a number such as K11, J5, etc. )   I do get an error stating type converion error, but the table field is text.
I'm confused and could use your help!  Thank you.
Question by:kshumway
  • 4
  • 3
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22981548
are you using an import specification? try editing the import specification

Author Comment

ID: 22983849
I guess I'm not sure what an import specification is.  I've attached how the Transfer is set up in the macro.  If there is something more, please enlighten me!  Thank  you!!!
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22984011
there is no import specification used in the macro.

try importing the csv to a non-existing (new) table
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 22984077
When I use a new table, it pulls the values in as currency.  Instead of using the macro, I used the statement:

DoCmd.TransferText acImportDelim, , "tblNew", _
        "\\ksqldb\dbapps\KathyTest\SpecimenCount\SpecimenCnt.csv", False

The second parameter is the specification?  How would I set one up?
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 22984223
to create an import specification

1. File>get external data>import
2. select in the File of types box   Text files (*.txt etc..
3. select the file
4. in the import text wizard window select  delimited
5. Click advanced
6. in the import specification window
    type the name of the field in the Field Name column
    (here you can use the field names of the destination table, specify data type,
      check the box Skip if you do not want to import the column)

7 click save as, give the specification a name  <-- this is the specification name that you will use in the command line


Author Comment

ID: 22984319
That worked!   Thank you so much!!!!!

Author Closing Comment

ID: 31517708
Worked perfectly!!!! Thank you.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question