Save Excel range to Access Database

%3CLINGO-SUB%20id%3D%22lingo-sub-2128000%22%20slang%3D%22en-US%22%3ESave%20Excel%20range%20to%20Access%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2128000%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Excel%20project%20that%20gathers%20data%20in%20a%20range%20(example%3A%20A2%3A%20J2).%20I%20need%20this%20range%20to%20be%20copied%20and%20inserted%20into%20an%20Access%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20do%20this%20to%20insert%20the%20range%20in%20another%20spreadsheet%2C%20but%20I%20want%20to%20move%20my%20projects%20to%20something%20more%20robust%2C%20like%20Access.%20What%20should%20I%20do%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20have%20already%20created%20a%20table%20in%20Access%20that%20I%20believe%20is%20correct%2C%20however%2C%20I%20am%20grateful%20if%20you%20can%20provide%20me%20with%20extra%20tips.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2128000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2130731%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20Excel%20range%20to%20Access%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2130731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F964793%22%20target%3D%22_blank%22%3E%40LeandroCampacci%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaven't%20used%20Access%20in%20years%2C%20decades%20actually.%20I%20have%20to%20imagine%20that%20there's%20a%20simple%20File....Import%20option%20in%20Access.%20And%20probably%20an%20equally%20simple%20File....Export...%26nbsp%3B%20probably%20to%20CSV%20format%2C%20in%20Excel.%20Take%20a%20look%20under%20each%20program's%20File%20menu%20for%20things%20along%20those%20lines.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2136494%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20Excel%20range%20to%20Access%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3Bsorry%2C%20an%20important%20detail%20was%20missing%3A%20Imagine%20that%20this%20Excel%20spreadsheet%20works%20as%20a%20register%2C%20in%20which%20a%20user%20will%20fill%20in%20and%20that%20the%20values%20entered%20must%20be%20transported%20to%20Access.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone!

 

I have an Excel project that gathers data in a range (example: A2: J2). I need this range to be copied and inserted into an Access table.

 

I know how to do this to insert the range in another spreadsheet, but I want to move my projects to something more robust, like Access. What should I do?


I have already created a table in Access that I believe is correct, however, I am grateful if you can provide me with extra tips.

3 Replies

@LeandroCampacci 

 

Haven't used Access in years, decades actually. I have to imagine that there's a simple File....Import option in Access. And probably an equally simple File....Export...  probably to CSV format, in Excel. Take a look under each program's File menu for things along those lines.

@mathetes sorry, an important detail was missing: Imagine that this Excel spreadsheet works as a register, in which a user will fill in and that the values ​​entered must be transported to Access.

@LeandroCampacci 

 

Again, I haven't used Access in decades. You're using Access, according to your first message, because it is "more robust." Is there some reason, then, why the data entry can't be done directly into Access? Why is the entry into Excel--if it's only data entry--even a necessary step.

 

I'm sure there's an Access community corresponding to this one for Excel--may I suggest you pose the question there? I'd be surprised if it weren't possible to dispense with Excel as a component in your process of data collection.

 

Although it's also possible--entirely possible--that another person here in the Excel techcommunity will have a solution for you.