Microsoft Access Import problems!

PB3 · 11-10-2010, 05:09 PM

Alright. A colleague of mine just emailed me a spreadsheet that he needs imported to access. I am usually good with this but I cannot get this to import correctly! I am f*cking loosing my mind!

Situation:
I copied and paste special his data onto an excel template I use. The query in access is set up to pull the data from this template and import it into access. I plug in all the data, hit the import button, and for some reason it will not pull in any numbers with letters next to it.

Example:

Here is the data. Try and picture it in an excel spreadsheet..

10000 12615
10000 12545
1502LO 56134
1504GR 56134

When I import the data into access this is what I get:

10000 12615
10000 12545
*BLANK*56134
*BLANK*56134

I have tried copying and paste special into a blank spread sheet then copying from there and paste special into my template and I still get blanks on numbers with letters next to them! It doesn't say "*BLANK*" as I described above. The cell is blank.HELP!!

brandotron · 11-10-2010, 05:18 PM

Quote:

Originally Posted by PB3

Alright. A colleague of mine just emailed me a spreadsheet that he needs imported to access. I am usually good with this but I cannot get this to import correctly! I am f*cking loosing my mind!

Situation:
I copied and paste special his data onto an excel template I use. The query in access is set up to pull the data from this template and import it into access. I plug in all the data, hit the import button, and for some reason it will not pull in any numbers with letters next to it.

Example:

Here is the data. Try and picture it in an excel spreadsheet..

10000 12615
10000 12545
1502LO 56134
1504GR 56134

When I import the data into access this is what I get:

10000 12615
10000 12545
*BLANK*56134
*BLANK*56134

I have tried copying and paste special into a blank spread sheet then copying from there and paste special into my template and I still get blanks on numbers with letters next to them! It doesn't say "*BLANK*" as I described above. The cell is blank.HELP!!

If it's anything like SQL/mySQL, you need to specify that the left column is NVARCHAR, rather than NUMERIC

PB3 · 11-10-2010, 05:30 PM

Well, I've just imported different spreadsheets I have with similar data to make sure no one f*cked with my access query. They import the data just fine. Could it be something with his excel spreadsheet?

KMSRS2SS · 11-10-2010, 07:30 PM

Is there any formatting going on in the excel column? Try just a general formatting see if that changes anything.

11-10-2010, 05:09 PM	#1
PB3 Drives: 2010 CGM 2LT/RS/GFX/M6 Join Date: Jan 2010 Location: San Antonio, TX Posts: 1,689	Microsoft Access Import problems! Alright. A colleague of mine just emailed me a spreadsheet that he needs imported to access. I am usually good with this but I cannot get this to import correctly! I am fcking loosing my mind! Situation: I copied and paste special his data onto an excel template I use. The query in access is set up to pull the data from this template and import it into access. I plug in all the data, hit the import button, and for some reason it will not pull in any numbers with letters next to it. Example: Here is the data. Try and picture it in an excel spreadsheet.. 10000 12615 10000 12545 1502LO 56134 1504GR 56134 When I import the data into access this is what I get: 10000 12615 10000 12545 BLANK56134 BLANK56134 I have tried copying and paste special into a blank spread sheet then copying from there and paste special into my template and I still get blanks on numbers with letters next to them! It doesn't say "BLANK*" as I described above. The cell is blank.HELP!! __________________ "Reality is an illusion that occurs due to lack of alcohol" -W.C.Feilds

11-10-2010, 05:30 PM	#3
PB3 Drives: 2010 CGM 2LT/RS/GFX/M6 Join Date: Jan 2010 Location: San Antonio, TX Posts: 1,689	Well, I've just imported different spreadsheets I have with similar data to make sure no one f*cked with my access query. They import the data just fine. Could it be something with his excel spreadsheet? __________________ "Reality is an illusion that occurs due to lack of alcohol" -W.C.Feilds

11-10-2010, 07:30 PM	#4
KMSRS2SS I lurk Drives: 2010 SS/RS Join Date: Aug 2009 Location: MI. Posts: 309 View My Garage	Is there any formatting going on in the excel column? Try just a general formatting see if that changes anything. __________________ 460 at the wheel so far... VMS Stage 2.5 Camshaft Kit- Comp cam LSA 114,227/239, .613 .623, RotoFab CAI, VMS ported intake manifold,Kooks 1 3/4" headers with HF cats, Corsa Catback, VMS custom dyno tune,TechAFX engine hose relocation kit, DSS 1400 hp axles, BMR toe rods and links, LS9 Clutch, Hurst short throw with roll out, Liberty Gear built tremec 6060.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic Transmission Problems	Kyzer	Camaro Issues / Problems \| Warranty Discussions \| TSB and Recalls	30	07-13-2016 07:26 PM
Potential Solutions to Radio Problems	The_Blur	Audio, Video, Bluetooth, Navigation, Radar, Electronics Forum	17	11-10-2009 11:23 PM
Does an axle back have the same problems as a cat back?	G.E.	Camaro V8 LS3 / L99 Engine, Exhaust, and Bolt-Ons	2	09-15-2009 04:31 PM
Problems with Active Fuel Management ?	2SSRS@Gen5diy	Camaro V8 LS3 / L99 Engine, Exhaust, and Bolt-Ons	73	04-08-2009 04:15 AM
ordering problems at the dealer?	pinkcamaro10	Camaro Price \| Ordering \| Tracking \| Dealers Discussions	27	10-14-2008 12:43 AM