Recent content by kcarpy

Of course. I don't know why I didn't think of that. Thank you!

Hi. I'm working on a form that lets the user import data from another Access database. I'd like to let them choose a database from a particular path. In order to do that, I'd like to have a combo box containing the names of all Access files in that path. I am able to get all the files with this...

Ah, okay, so there's nothing native to Access that works. I thought maybe I was missing something. It's past time I started learning some scripting languages, and this sounds like a good way to start. Thanks!

Yes, I can get to that. It's not that I need to convert the data into columns. That's simple, and Access can do it too. It's that I need a way to convert a very long single line of data into multiple rows at every fifth delimiter. I don't see any way of doing that. Right now it's like this...

What can Excel's wizard do that Access's can't? I don't see anything that will let me define end of line information, just set delimiters. Am I missing something?

Greetings. I have an issue with getting data converted to some sort of format that would be more friendly to databases than its current form, and I'm wondering if anyone here would have some advice. It's a big dataset, around 200,000 records, and they are in tab-delimited format. Unfortunately...

Ah, I was working with faulty info then. Thanks!

I'm using Access.

Hi. I'm currently frustrating myself to death trying to figure out why this isn't working. I want to create a table using SQL (or VB if necessary) that has validation code, and I've been told I should use check constraints to do that. However, I can't seem to get check constraints to work at...

Thanks. My issue is that it's a bunch of spreadsheets, all with the data set up the same way, and I'll need to do it repeatedly, so I wanted to just write code to do it. I think what I'll do is simply create the import tables first, set the field properties, and then import into those tables...

Hi. I'm wondering if there is a way to define the settings for each column to be imported when importing from Excel using TransferSpreadsheet. As an example, I am trying to import a four-column spreadsheet from excel in which the first column contains mostly numeric but a few text entries. I...

Thanks. I'll check out the tableDef object. I don't mind using VBA. I'm basically building tables with runSQL statements (I'm a bit of a novice, so this is the best way I know), so I thought it might be simpler to just add it if there were an SQL way of doing it. If it's easier don in VBA, I...

Hello to all. First time poster. I have a question about creating tables in Access with an SQL query (or VBA, I guess, if that's not possible, though my example below is SQL). Specifically, I'd like to know how one adds validation rules programmatically. For some reason, I can't seem to find...