General discussion


Error Importing Access file into SQL Server 2008

By abe_froman ·
I am trying to import a large Access(.mdb) file into SQL Server 2008, and I'm getting the messages below. Any ideas?

- Pre-execute (Error)
Error 0xc0202004: Data Flow Task 1: The number of columns is incorrect.
(SQL Server Import and Export Wizard)

Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task 1: component "Destination - Parnell_Byte_Mgrs_Pt2" (61) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard)

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Work around

by abe_froman In reply to Error Importing Access fi ...

I was trying to import 3.5 million rows. After numerous failed attempts to import the file as .mdb or as .txt, I tried another approach. I took my wife's advice and split it into two .txt files of near equal size. It worked, I just combined the two tables in SSMS with a UNION ALL. NOTE: Had to use TextPad, wouldn't fit in NotePad.

Related Discussions

Related Forums