Importing Excel data into Access - error message

[shindig54]

Hello, I downloaded a year's worth of financial transaction data into Excel and exceeded the limit on one sheet but the data did download into 2 sheets. When I try to import into Access (even in just a blank data able) I receive the following "Cannot open database. It may not be a database your application recognizes, or the file may be corrupt". Can anyone help me? Thank you.

 

[shindig54]

I wish I could send it to you but one file is 244MG and the other is 220MG, I don't think there is a way for me to get it to you. I really appreciate your help, though.

 

[Micron]

file share?
If not, that's OK but I'm out of ideas except what I suggested in my last post.

 

[shindig54]

Sorry, what is file share?

 

[Micron]

something like Google Drive? There are lots of different ones whose names I don't recall but have downloaded from in the past. Not my favourite source as I'd rather download from a forum. Just seems safer and free of ads but I admit to downloading db's from such sources. I guess you've never used one.

 

[shindig54]

I really appreciate your help but I probably can't get authorization to share the data. I noticed that the data I am trying to pull has a * as the first field. I wasn't sure what that was so I kept ignoring it. I pulled it in and received a different error message:

Duplicate output destination "Transaction Type"

I don't have duplicate fields called "transaction Type".

 

[shindig54]

I did notice if I pull one table into one database and the other table into a different database, they will both load and open but I still can't combine them.

 

[Micron]

Why can't you combine them? You can link one table from each db into a 3rd if necessary and combine in the one. Almost sounds like there are too many records for Access? Access db file limit is 2 Gb, including any overhead. If a file is less than that but needs reserve space for processing then you'll run in to issues with size.