Re: Simple Copy and Paste from Excel to Access

If you are looking for a solution that would not require the user to have a
licensed version of Access then the INSERT / SQL way is your best bet...

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/


"Marky" <z@xxxxx> wrote in message
news:iyY4e.7411278$f47.1363832@xxxxxxxxxxxxxxxxxxxx
> Hi Group.
>
> I am looking for some very simple code, nothing flash to just copy and
paste
> into an access database.
>
> What i can do is open and close the files in both excel and access but i
> cant just get a simple copy and paste to work.
> I have tried to even do it via the macro recorder but no joy.
>
> There is only 5 rows and columns in excel (A1 to E5) to copy into table4
of
> my database which is structured. The table is empty and purely just needs
to
> be pasted in like would when doing it manually.
>
> Any ideas on this, i have looked into the INSERT way of doing it but it
has
> to loop via each row doesnt it? , is there not just a copy and paste
> method?
>
> Thanks!
>
>


.

Relevant Pages

  • Re: Getting the Stored Procedure ReturnValue and a recordset at the same time.
    ... Understanding the SQL Server Return ... >> See my article on handling stored procedure parameters in SPs on my site. ... >> Microsoft MVP ...
    (microsoft.public.vb.database.ado)
  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Anyone tell me whats wrong with this SQL statement?
    ... That sounds like an SQL error telling you that you are not accounting ... am also working on a Photo Album which uses an Access ... > PS - just to cover every area, the data types in Access database are as ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: VB or?
    ... I know you can use an Access database with it, but it's not the standard, instead using compact SQL for the desktop, or the free version of SQL would be the more "in the box" approaches. ... If you haven't been programming for 12 years, then I'd suggest try the .NET version and see how you go. ... You can buy a .NET standard version and downgrade I believe, but not sure on that status now as officially VB6 is no longer a supported product. ...
    (microsoft.public.vb.general.discussion)
  • Re: Calling SQL Stored Proc from Access (with Parameters)
    ... You can put the code in the after update of your "form field". ... property of the pass-through query. ... I have an access database and a SQL database. ...
    (microsoft.public.access.queries)