Access in between Excel and textfile

[Jaymond Flurrie]

edit. So far this seems easier than I thought.

 

[Jaymond Flurrie]

Ok, now I am able to create an Access DB-table-field combination using Excel VBA. Here's the current problem:

"CREATE TABLE atable ([afield] byte WITH Compression)"

Otherwise nice, but that byte doesn't seem to work. I have nothing but ones and zeros as the data (I later need the sum of those), so what's the smartest field type? Can I sum up a yesno-field? I really think this is possible to do with some way smaller type than integer.

Also, what's the use for "compression"? It makes the db smaller, right? But how much slower it makes the db?

 

[Jaymond Flurrie]

At least

CREATE TABLE atable (afield bit)

seems to work.

 

[xenou]

Looks good to me. NUMBER (Fieldsize = BYTE) might work too, as given here:
http://msdn.microsoft.com/en-us/library/ms714540(v=vs.85).aspx

With compression should only matter for Text or Memo. It compresses Unicode double byte characters to single byte storage when possible:
http://msdn.microsoft.com/en-us/library/bb177893(v=office.12).aspx

 

[Jaymond Flurrie]

Looks good to me. NUMBER (Fieldsize = BYTE) might work too, as given here:
http://msdn.microsoft.com/en-us/library/ms714540(v=vs.85).aspx

With compression should only matter for Text or Memo. It compresses Unicode double byte characters to single byte storage when possible:
http://msdn.microsoft.com/en-us/library/bb177893(v=office.12).aspx

Sounds good, thanks for the info!