Cannot Open File Using MS Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1421514%22%20slang%3D%22en-US%22%3ECannot%20Open%20File%20Using%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421514%22%20slang%3D%22en-US%22%3E%3CP%3EI%20get%20an%20error%20when%20opening%20a%20csv%20file%20using%20Access.%26nbsp%3B%20The%20Link%20Text%20Wizard%20tells%20me%20I%20have%20a%20%22bad%20file%20name%20or%20number%22.%20I%20tried%20renaming%20it%20and%20that%20did%20not%20work.%26nbsp%3B%20The%20file%20is%20large....%206%2C526%2C457%20KB.%20I%20am%20an%20Access%20rookie.%26nbsp%3B%20%26nbsp%3B%20Is%20file%20too%20large%20or%20am%20I%20doing%20something%20wrong%3F%26nbsp%3B%20I%20am%20able%20to%20open%20other%20smaller%20files%20without%20a%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1421514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1424492%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Open%20File%20Using%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1424492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681338%22%20target%3D%22_blank%22%3E%40MattStumm%3C%2FA%3E%26nbsp%3BHow%20many%20columns%20does%20the%20csv%20file%20have%3F%20How%20many%20rows%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I get an error when opening a csv file using Access.  The Link Text Wizard tells me I have a "bad file name or number". I tried renaming it and that did not work.  The file is large.... 6,526,457 KB. I am an Access rookie.    Is file too large or am I doing something wrong?  I am able to open other smaller files without a problem.

1 Reply
Highlighted

@MattStumm How many columns does the csv file have? How many rows?