Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access getting on my nerves

 
Johannes Thorén
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, so i got a huuuge problem!

I made a Database in MS Access 2003, containing 16 tables.
My problem now is to insert data intoo these tables. And for some reason i cant seam to run more then
one SQL (INSERT INTO) statement at the same time in Access, wich would make it take forever to insert my data
into my tables.

So now im thinking, maybe i should do an Java Application to insert the data for me.

I didint know in what forum to put this thread, I'm a bit mad at the moment hehe..

My question is,
Is there any easyer way to insert the data intoo the tables then creating a Java App?
If not, what do i need to know to make this work? How do i connect a Java program to my .mdb file?

Thanks in advance.

// Shaggy
 
Paul Clapham
Sheriff
Posts: 21546
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Johannes Thorén wrote:And for some reason i cant seam to run more then
one SQL (INSERT INTO) statement at the same time in Access, wich would make it take forever to insert my data
into my tables.

So now im thinking, maybe i should do an Java Application to insert the data for me.


I don't get it. You don't have a Java application yet? Then what do you have? And what's your problem with it? It sounds like you are trying to use multiple threads to do simultaneous inserts, which I would expect to cause problems, but that's just my guess at what you said. Perhaps a description of your existing problem would help.
 
Johannes Thorén
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The problem i have, is that i cant enter several rows of data into my tables in Microsoft Access 2003 at the same time.
So im looking for a solution, and im wondering if there is some easyer way then making an entire java application for it.

Or if not where should i begin?

It's making me nuts hehe
 
Andrew Monkhouse
author and jackaroo
Marshal Commander
Pie
Posts: 12007
215
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you looked at the Microsoft support document for importing data?
 
Paul Clapham
Sheriff
Posts: 21546
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Johannes Thorén wrote:The problem i have, is that i cant enter several rows of data into my tables in Microsoft Access 2003 at the same time.

Who says so? Is that because you only have one keyboard to type on, or what? There's no point in trying to suggest replacements for your existing failed solution without knowing why it failed.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic