PC Review

Thread Tools Rate Thread

Help with Importing from Excel into Access

New Member
Join Date: Jul 2012
Posts: 1
      5th Jul 2012
Hey all, first post on this site!I have read quite a few posts on this matter but I cannot find an answer for my case, or one that I can change to fit me, for that matter.

I have an excel sheet that has numbers as well as "#N/A" cells in it. When I import these cells into Access, the cells that have "#N/A" are not importing. I know that this is a Type Conversion Failure and why it is doing it.

I cannot change the input excel file. I am looking for an alternative way to either A. get these in from the input, or B. look into the ImportErrors file that is created and add these values into the other sheet from this. This is how I am inputting it.

DoCmd.TransferSpreadsheet acImport, , "source", source_plus_name, True
I know that I could change to TransferText, but this is is causing: "Run-Time error '31519': You cannot import this file."

Would it be easier to create a temporary file and do TransferText (even though most are numbers), or find a way to do one of the two things I posted above?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help importing Access Choose function into excel. George Microsoft Access Queries 1 13th Aug 2009 05:55 PM
HELP: Importing an Excel file into Access 2000 =?Utf-8?B?R29l?= Microsoft Access External Data 5 18th Aug 2005 04:01 PM
Help With importing Outlook email time stamps into Access or Excel =?Utf-8?B?TmF0aGFu?= Microsoft Access External Data 0 8th Nov 2004 03:28 PM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM
Importing excel into access - want access to update data supplied from excel Deborah Microsoft Access External Data 1 30th Jul 2003 01:21 PM




All times are GMT +1. The time now is 03:28 PM.